eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JG_ZZ_SUMMARY_ALL_PKG dependencies on STANDARD

Line 366: fnd_file.put_line(fnd_file.log,'Cannot find Activity Code (Standard Inductry Classification Code for Legal Entity:'||l_legal_entity_id);

362: FROM xle_entity_profiles
363: WHERE legal_entity_id = l_legal_entity_id;
364: EXCEPTION
365: WHEN NO_DATA_FOUND THEN
366: fnd_file.put_line(fnd_file.log,'Cannot find Activity Code (Standard Inductry Classification Code for Legal Entity:'||l_legal_entity_id);
367: WHEN OTHERS THEN
368: fnd_file.put_line(fnd_file.log,'Error While retriving Activity Code for Legal Entity:'||l_legal_entity_id);
369: fnd_file.put_line(fnd_file.log,'Error Message :'||SUBSTR(SQLERRM,1,200));
370: END;

Line 1677: ,JZVTD.TRX_ID INV_ID_STANDARD

1673:
1674: CURSOR q_ap_invoices IS
1675: SELECT JZVRS.VAT_REPORTING_ENTITY_ID REPORTING_ENTITY
1676: ,1 COUNT_STD_INV, DECODE(JZVTD.REPORTING_CODE, 'VAT-C', 'C','VAT-P','P','VAT-H','H','T') CLASS
1677: ,JZVTD.TRX_ID INV_ID_STANDARD
1678: ,NVL(AP.GLOBAL_ATTRIBUTE1,'0000') REFERENCE_GROUP
1679: ,JG_ZZ_SUMMARY_ALL_PKG.JEILR835_INV_NUM(JZVTD.TRX_NUMBER) INV_NUMBER_STANDARD
1680: ,TO_CHAR(JZVTD.TRX_DATE,'RRRRMMDD') INV_DATE_STANDARD
1681: ,JZVTD.TRX_LINE_CLASS TRX_LINE_CLASS

Line 1679: ,JG_ZZ_SUMMARY_ALL_PKG.JEILR835_INV_NUM(JZVTD.TRX_NUMBER) INV_NUMBER_STANDARD

1675: SELECT JZVRS.VAT_REPORTING_ENTITY_ID REPORTING_ENTITY
1676: ,1 COUNT_STD_INV, DECODE(JZVTD.REPORTING_CODE, 'VAT-C', 'C','VAT-P','P','VAT-H','H','T') CLASS
1677: ,JZVTD.TRX_ID INV_ID_STANDARD
1678: ,NVL(AP.GLOBAL_ATTRIBUTE1,'0000') REFERENCE_GROUP
1679: ,JG_ZZ_SUMMARY_ALL_PKG.JEILR835_INV_NUM(JZVTD.TRX_NUMBER) INV_NUMBER_STANDARD
1680: ,TO_CHAR(JZVTD.TRX_DATE,'RRRRMMDD') INV_DATE_STANDARD
1681: ,JZVTD.TRX_LINE_CLASS TRX_LINE_CLASS
1682: ,JZVTD.BILLING_TP_NUMBER VEN_NUM_STANDARD
1683: ,NVL(LPAD(SUBSTR(NVL(JZVTD.BILLING_TP_SITE_TAX_REG_NUM, JZVTD.BILLING_TP_TAX_REG_NUM),1,9),9,'0'),'000000000') TAX_REG_NUM_STANDARD

Line 1680: ,TO_CHAR(JZVTD.TRX_DATE,'RRRRMMDD') INV_DATE_STANDARD

1676: ,1 COUNT_STD_INV, DECODE(JZVTD.REPORTING_CODE, 'VAT-C', 'C','VAT-P','P','VAT-H','H','T') CLASS
1677: ,JZVTD.TRX_ID INV_ID_STANDARD
1678: ,NVL(AP.GLOBAL_ATTRIBUTE1,'0000') REFERENCE_GROUP
1679: ,JG_ZZ_SUMMARY_ALL_PKG.JEILR835_INV_NUM(JZVTD.TRX_NUMBER) INV_NUMBER_STANDARD
1680: ,TO_CHAR(JZVTD.TRX_DATE,'RRRRMMDD') INV_DATE_STANDARD
1681: ,JZVTD.TRX_LINE_CLASS TRX_LINE_CLASS
1682: ,JZVTD.BILLING_TP_NUMBER VEN_NUM_STANDARD
1683: ,NVL(LPAD(SUBSTR(NVL(JZVTD.BILLING_TP_SITE_TAX_REG_NUM, JZVTD.BILLING_TP_TAX_REG_NUM),1,9),9,'0'),'000000000') TAX_REG_NUM_STANDARD
1684: ,SUM(NVL(JZVTD.TAX_AMT_FUNCL_CURR,JZVTD.TAX_AMT)) VAT_AMOUNT_STANDARD

Line 1682: ,JZVTD.BILLING_TP_NUMBER VEN_NUM_STANDARD

1678: ,NVL(AP.GLOBAL_ATTRIBUTE1,'0000') REFERENCE_GROUP
1679: ,JG_ZZ_SUMMARY_ALL_PKG.JEILR835_INV_NUM(JZVTD.TRX_NUMBER) INV_NUMBER_STANDARD
1680: ,TO_CHAR(JZVTD.TRX_DATE,'RRRRMMDD') INV_DATE_STANDARD
1681: ,JZVTD.TRX_LINE_CLASS TRX_LINE_CLASS
1682: ,JZVTD.BILLING_TP_NUMBER VEN_NUM_STANDARD
1683: ,NVL(LPAD(SUBSTR(NVL(JZVTD.BILLING_TP_SITE_TAX_REG_NUM, JZVTD.BILLING_TP_TAX_REG_NUM),1,9),9,'0'),'000000000') TAX_REG_NUM_STANDARD
1684: ,SUM(NVL(JZVTD.TAX_AMT_FUNCL_CURR,JZVTD.TAX_AMT)) VAT_AMOUNT_STANDARD
1685: ,SUM(NVL(JZVTD.TAXABLE_AMT_FUNCL_CURR, JZVTD.TAXABLE_AMT)) TAXABLE_AMOUNT_STANDARD
1686: FROM

Line 1683: ,NVL(LPAD(SUBSTR(NVL(JZVTD.BILLING_TP_SITE_TAX_REG_NUM, JZVTD.BILLING_TP_TAX_REG_NUM),1,9),9,'0'),'000000000') TAX_REG_NUM_STANDARD

1679: ,JG_ZZ_SUMMARY_ALL_PKG.JEILR835_INV_NUM(JZVTD.TRX_NUMBER) INV_NUMBER_STANDARD
1680: ,TO_CHAR(JZVTD.TRX_DATE,'RRRRMMDD') INV_DATE_STANDARD
1681: ,JZVTD.TRX_LINE_CLASS TRX_LINE_CLASS
1682: ,JZVTD.BILLING_TP_NUMBER VEN_NUM_STANDARD
1683: ,NVL(LPAD(SUBSTR(NVL(JZVTD.BILLING_TP_SITE_TAX_REG_NUM, JZVTD.BILLING_TP_TAX_REG_NUM),1,9),9,'0'),'000000000') TAX_REG_NUM_STANDARD
1684: ,SUM(NVL(JZVTD.TAX_AMT_FUNCL_CURR,JZVTD.TAX_AMT)) VAT_AMOUNT_STANDARD
1685: ,SUM(NVL(JZVTD.TAXABLE_AMT_FUNCL_CURR, JZVTD.TAXABLE_AMT)) TAXABLE_AMOUNT_STANDARD
1686: FROM
1687: JG_ZZ_VAT_TRX_DETAILS JZVTD

Line 1684: ,SUM(NVL(JZVTD.TAX_AMT_FUNCL_CURR,JZVTD.TAX_AMT)) VAT_AMOUNT_STANDARD

1680: ,TO_CHAR(JZVTD.TRX_DATE,'RRRRMMDD') INV_DATE_STANDARD
1681: ,JZVTD.TRX_LINE_CLASS TRX_LINE_CLASS
1682: ,JZVTD.BILLING_TP_NUMBER VEN_NUM_STANDARD
1683: ,NVL(LPAD(SUBSTR(NVL(JZVTD.BILLING_TP_SITE_TAX_REG_NUM, JZVTD.BILLING_TP_TAX_REG_NUM),1,9),9,'0'),'000000000') TAX_REG_NUM_STANDARD
1684: ,SUM(NVL(JZVTD.TAX_AMT_FUNCL_CURR,JZVTD.TAX_AMT)) VAT_AMOUNT_STANDARD
1685: ,SUM(NVL(JZVTD.TAXABLE_AMT_FUNCL_CURR, JZVTD.TAXABLE_AMT)) TAXABLE_AMOUNT_STANDARD
1686: FROM
1687: JG_ZZ_VAT_TRX_DETAILS JZVTD
1688: ,JG_ZZ_VAT_REP_STATUS JZVRS

Line 1685: ,SUM(NVL(JZVTD.TAXABLE_AMT_FUNCL_CURR, JZVTD.TAXABLE_AMT)) TAXABLE_AMOUNT_STANDARD

1681: ,JZVTD.TRX_LINE_CLASS TRX_LINE_CLASS
1682: ,JZVTD.BILLING_TP_NUMBER VEN_NUM_STANDARD
1683: ,NVL(LPAD(SUBSTR(NVL(JZVTD.BILLING_TP_SITE_TAX_REG_NUM, JZVTD.BILLING_TP_TAX_REG_NUM),1,9),9,'0'),'000000000') TAX_REG_NUM_STANDARD
1684: ,SUM(NVL(JZVTD.TAX_AMT_FUNCL_CURR,JZVTD.TAX_AMT)) VAT_AMOUNT_STANDARD
1685: ,SUM(NVL(JZVTD.TAXABLE_AMT_FUNCL_CURR, JZVTD.TAXABLE_AMT)) TAXABLE_AMOUNT_STANDARD
1686: FROM
1687: JG_ZZ_VAT_TRX_DETAILS JZVTD
1688: ,JG_ZZ_VAT_REP_STATUS JZVRS
1689: ,AP_INVOICES_ALL AP

Line 2221: ,lpad(l_ap_invoices.tax_reg_num_standard,9,'0')

2217: )
2218: VALUES
2219: (
2220: l_ap_invoices.class
2221: ,lpad(l_ap_invoices.tax_reg_num_standard,9,'0')
2222: ,l_ap_invoices.inv_date_standard
2223: ,l_ap_invoices.reference_group
2224: ,l_ap_invoices.inv_number_standard
2225: ,lpad(round(abs(l_ap_invoices.vat_amount_standard)),9,'0')

Line 2222: ,l_ap_invoices.inv_date_standard

2218: VALUES
2219: (
2220: l_ap_invoices.class
2221: ,lpad(l_ap_invoices.tax_reg_num_standard,9,'0')
2222: ,l_ap_invoices.inv_date_standard
2223: ,l_ap_invoices.reference_group
2224: ,l_ap_invoices.inv_number_standard
2225: ,lpad(round(abs(l_ap_invoices.vat_amount_standard)),9,'0')
2226: ,decode(sign(l_ap_invoices.taxable_amount_standard),'-1','-','+')

Line 2224: ,l_ap_invoices.inv_number_standard

2220: l_ap_invoices.class
2221: ,lpad(l_ap_invoices.tax_reg_num_standard,9,'0')
2222: ,l_ap_invoices.inv_date_standard
2223: ,l_ap_invoices.reference_group
2224: ,l_ap_invoices.inv_number_standard
2225: ,lpad(round(abs(l_ap_invoices.vat_amount_standard)),9,'0')
2226: ,decode(sign(l_ap_invoices.taxable_amount_standard),'-1','-','+')
2227: ,lpad(round(abs(nvl(l_ap_invoices.taxable_amount_standard,0))),10,'0')
2228: ,l_ap_invoices.inv_date_standard

Line 2225: ,lpad(round(abs(l_ap_invoices.vat_amount_standard)),9,'0')

2221: ,lpad(l_ap_invoices.tax_reg_num_standard,9,'0')
2222: ,l_ap_invoices.inv_date_standard
2223: ,l_ap_invoices.reference_group
2224: ,l_ap_invoices.inv_number_standard
2225: ,lpad(round(abs(l_ap_invoices.vat_amount_standard)),9,'0')
2226: ,decode(sign(l_ap_invoices.taxable_amount_standard),'-1','-','+')
2227: ,lpad(round(abs(nvl(l_ap_invoices.taxable_amount_standard,0))),10,'0')
2228: ,l_ap_invoices.inv_date_standard
2229: ,'JEILR835'

Line 2226: ,decode(sign(l_ap_invoices.taxable_amount_standard),'-1','-','+')

2222: ,l_ap_invoices.inv_date_standard
2223: ,l_ap_invoices.reference_group
2224: ,l_ap_invoices.inv_number_standard
2225: ,lpad(round(abs(l_ap_invoices.vat_amount_standard)),9,'0')
2226: ,decode(sign(l_ap_invoices.taxable_amount_standard),'-1','-','+')
2227: ,lpad(round(abs(nvl(l_ap_invoices.taxable_amount_standard,0))),10,'0')
2228: ,l_ap_invoices.inv_date_standard
2229: ,'JEILR835'
2230: ,decode(l_ap_invoices.class,'T','10Q_AP_INVOICES',

Line 2227: ,lpad(round(abs(nvl(l_ap_invoices.taxable_amount_standard,0))),10,'0')

2223: ,l_ap_invoices.reference_group
2224: ,l_ap_invoices.inv_number_standard
2225: ,lpad(round(abs(l_ap_invoices.vat_amount_standard)),9,'0')
2226: ,decode(sign(l_ap_invoices.taxable_amount_standard),'-1','-','+')
2227: ,lpad(round(abs(nvl(l_ap_invoices.taxable_amount_standard,0))),10,'0')
2228: ,l_ap_invoices.inv_date_standard
2229: ,'JEILR835'
2230: ,decode(l_ap_invoices.class,'T','10Q_AP_INVOICES',
2231: 'C','20Q_AP_INVOICES',

Line 2228: ,l_ap_invoices.inv_date_standard

2224: ,l_ap_invoices.inv_number_standard
2225: ,lpad(round(abs(l_ap_invoices.vat_amount_standard)),9,'0')
2226: ,decode(sign(l_ap_invoices.taxable_amount_standard),'-1','-','+')
2227: ,lpad(round(abs(nvl(l_ap_invoices.taxable_amount_standard,0))),10,'0')
2228: ,l_ap_invoices.inv_date_standard
2229: ,'JEILR835'
2230: ,decode(l_ap_invoices.class,'T','10Q_AP_INVOICES',
2231: 'C','20Q_AP_INVOICES',
2232: 'H','30Q_AP_INVOICES',