APPS.JE_ZZ_AUDIT_AP_PKG dependencies on JG_ZZ_VAT_TRX_GT

Line 77: FROM jg_zz_vat_trx_gt;

73:
74:
75: CURSOR company_info IS
76: SELECT DISTINCT jg_info_v5
77: FROM jg_zz_vat_trx_gt;
78:
79: CURSOR C_GENERIC(p_start_date DATE, p_end_date DATE) IS
80: SELECT SUBSTR(ven.vendor_name, 1, 10) ven_name
81: ,SUBSTR(ven.segment1, 1, 8) ven_no

Line 222: FROM JG_ZZ_VAT_TRX_GT

218: ,jg_info_n10 l_real_inv_amt
219: ,jg_info_n11 l_txbl_disc_amt
220: ,jg_info_n12 l_payment_amt
221: ,jg_info_d2 check_void_date
222: FROM JG_ZZ_VAT_TRX_GT
223: WHERE jg_info_v30='JEFRTXDC'
224: GROUP BY jg_info_n8
225: ,jg_info_n7
226: ,jg_info_n1

Line 520: INSERT INTO JG_ZZ_VAT_TRX_GT

516:
517:
518:
519:
520: INSERT INTO JG_ZZ_VAT_TRX_GT
521: (
522: jg_info_n1
523: ,jg_info_v1
524: ,jg_info_v2

Line 626: INTO jg_zz_vat_trx_gt(

622: -- negative for this line
623: --4. Payment amount will be null for a DEB/M invoice
624: --5. A DEB/M prepayment invoice will be picked up if it satisfies conditions 1
625: INSERT
626: INTO jg_zz_vat_trx_gt(
627: jg_info_v2 --ven_name
628: , jg_info_v3 --ven_no
629: , jg_info_n18 --recoverable_tax_amount
630: , jg_info_n2 --rec_per

Line 742: INTO jg_zz_vat_trx_gt(

738: -- line will appear on the invoice with amounts equal to the applied prepayment
739: -- amounts. This is necessary as tax on prepayment has already be reported (in Case 3).
740: -- Case 4 is handled in this query
741: INSERT
742: INTO jg_zz_vat_trx_gt(
743: jg_info_v2 --ven_name
744: , jg_info_v3 --ven_no
745: , jg_info_n18 --recoverable_tax_amount
746: , jg_info_n2 --rec_per

Line 845: INTO jg_zz_vat_trx_gt(

841: --7. Voiding a payment will result in an additional negative line being
842: -- picked up for the invoice. The payment amount, taxable amount and
843: -- recoverable tax amount will be negative for this line
844: INSERT
845: INTO jg_zz_vat_trx_gt(
846: jg_info_v2 --ven_name
847: , jg_info_v3 --ven_no
848: , jg_info_n18 --recoverable_tax_amount
849: , jg_info_n2 --rec_per

Line 980: INTO jg_zz_vat_trx_gt(

976: --
977: -- The first insert is for the positive line, the second insert
978: -- is for the negative line
979: INSERT
980: INTO jg_zz_vat_trx_gt(
981: jg_info_v2 --ven_name
982: , jg_info_v3 --ven_no
983: , jg_info_n18 --recoverable_tax_amount
984: , jg_info_n2 --rec_per

Line 1078: INTO jg_zz_vat_trx_gt(

1074:
1075:
1076:
1077: INSERT
1078: INTO jg_zz_vat_trx_gt(
1079: jg_info_v2 --ven_name
1080: , jg_info_v3 --ven_no
1081: , jg_info_n18 --recoverable_tax_amount
1082: , jg_info_n2 --rec_per

Line 1186: INTO jg_zz_vat_trx_gt(

1182: -- taxable amount will be prorated based on prepayment amount
1183: -- Taxable amount = (Original Taxable Amount)*(prepayment Amount/Invoice Amount)
1184: -- Recoverable tax amount = (Original Recoveral tax amount)*(prepayment Amount/Invoice Amount)
1185: INSERT
1186: INTO jg_zz_vat_trx_gt(
1187: jg_info_v2 --ven_name
1188: , jg_info_v3 --ven_no
1189: , jg_info_n18 --recoverable_tax_amount
1190: , jg_info_n2 --rec_per

Line 1316: UPDATE jg_zz_vat_trx_gt

1312: AND fif.id_flex_num = g_struct_num
1313: AND ffv.flex_value = c_balancing_segment.jg_info_v5
1314: AND ffv.flex_value_set_id = fif.flex_value_set_id;
1315:
1316: UPDATE jg_zz_vat_trx_gt
1317: SET jg_info_v10 = l_company_desc
1318: WHERE jg_info_v5 = c_balancing_segment.jg_info_v5;
1319: END LOOP;
1320:

Line 1353: INSERT INTO JG_ZZ_VAT_TRX_GT

1349:
1350: l_acc_no := get_accounting_segment(l_tax_ccid);
1351: l_company := get_balancing_segment(l_trx_ccid, l_company_desc);
1352:
1353: INSERT INTO JG_ZZ_VAT_TRX_GT
1354: (jg_info_v1 --ven_name
1355: ,jg_info_v2 --ven_no
1356: ,jg_info_v3 --inv_type
1357: ,jg_info_n1 --tax_amt