1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Need help to fetch hsn code from its master table

Discussion in 'General' started by abhishek chattaraj, Jul 14, 2017.

?

need help to fetch hsn code from its master table

  1. master table name

    0 vote(s)
    0.0%
  2. any other choices

    0 vote(s)
    0.0%
Multiple votes are allowed.
  1. abhishek chattaraj

    abhishek chattaraj Starter

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    10
    Location:
    kolkata
    need help to fetch hsn code from its master table
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,531
    Likes Received:
    360
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    What does that question even mean?
     
  3. abhishek chattaraj

    abhishek chattaraj Starter

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    10
    Location:
    kolkata
    Actually I need the master table of hsn_code . After launching of gst I pick the hsn_code from a invoice view table jai_tax_det_fct_lines_v. Its perfect for now. But I need the master table through which I can update/modify the hsn_code for requirement. Though I am in a production/outsourcing company I need it sir.
     
  4. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,531
    Likes Received:
    360
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    I have NO IDEA of what you are saying. You need to make your post CLEAR as to what application it is you are running and what this hsn table actually is. Your current question is very much like "my elephant has no carburetor, can you sell me spinach?"

    You really need to make your question clear to those who may not be intimately familiar with whatever it is you are using.
     
  5. abhishek chattaraj

    abhishek chattaraj Starter

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    10
    Location:
    kolkata
    module-ap
    oracle apps12

    how to calculate opening balance?

    Code (SQL):

    SELECT pv.VENDOR_TYPE_LOOKUP_CODE VENDOR_TYPE,
    pv.SEGMENT1 VENDOR_CODE,
    pvsa.VENDOR_SITE_CODE,
    pv.vendor_name VENDOR_NAME,
    pv.INVOICE_CURRENCY_CODE currency,
    NVL(SUM(tb.ACCTD_ROUNDED_CR),0)-
    NVL(SUM(tb.ACCTD_ROUNDED_DR),0) CLOSE_BLNC,
          NVL(SUM(tb.ACCTD_ROUNDED_CR),0) CREDIT,
    NVL(SUM(tb.ACCTD_ROUNDED_DR),0) DEBIT
    FROM
    xla_trial_balances tb
    ,PO_VENDORS pv
    ,po_vendor_sites_all pvsa
    WHERE      1=1
    AND pv.VENDOR_ID=pvsa.VENDOR_ID
    AND pv.vendor_id=tb.PARTY_ID
    AND tb.EVENT_CLASS_CODE<>'PREPAYMENTS'
    AND tb.EVENT_CLASS_CODE<>'PREPAYMENT APPLICATIONS'
    --AND pv.SEGMENT1='304'
    AND trunc(tb.GL_DATE) <= TO_DATE(:P_TO_DATE,'YYYY/MM/DD HH24:MI:SS')
    AND pv.vendor_id=NVL(:vendor_id,pv.vendor_id)
    --and pv.VENDOR_TYPE_LOOKUP_CODE=nvl(:v_type,pv.VENDOR_TYPE_LOOKUP_CODE)
    AND pv.segment1=nvl(:v_num,pv.segment1)
    AND pvsa.VENDOR_SITE_CODE=NVL(:v_site,pvsa.VENDOR_SITE_CODE)
    GROUP BY
    pv.SEGMENT1,
    pv.vendor_name,
    pv.VENDOR_TYPE_LOOKUP_CODE,
    pv.INVOICE_CURRENCY_CODE,
    pvsa.vendor_site_code
    ;