[Home] [Help]
129: AND XACA.assignment_owner_code = XAD.assignment_owner_code
130: AND XAD.ledger_id = P_ledger_id
131: AND XAD.enabled_flag = 'Y';
132: --
133: l_debug_info := 'Populate AP_ACCT_CLASS_CODE_GT';
134: --
135: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
136: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);
137: END IF;
138: --
139: IF acct_class_code_rec.l_acct_class_code_t.COUNT > 0 THEN
140: --
141: FOR i IN 1..acct_class_code_rec.l_acct_class_code_t.LAST LOOP
142: INSERT INTO AP_ACCT_CLASS_CODE_GT (
143: accounting_class_code)
144: VALUES(acct_class_code_rec.l_acct_class_code_t(i));
145: END LOOP;
146: --
145: END LOOP;
146: --
147: ELSE
148:
149: INSERT INTO AP_ACCT_CLASS_CODE_GT (
150: accounting_class_code)
151: SELECT XACA.accounting_class_code
152: FROM xla_acct_class_assgns XACA,
153: xla_assignment_defns_b XAD,
828: po_line_types_b POLT,
829: -- mtl_system_items MTLSI,
830: xla_distribution_links XDL,
831: xla_ae_lines XAL,
832: ap_acct_class_code_gt AAGT ,
833: xla_ae_headers XAH,
834: ap_alc_ledger_gt ALGT
835: WHERE APIDG.po_distribution_id = POD.po_distribution_id(+)
836: AND API.invoice_id = APIL.invoice_id
1333: po_line_types_b POLT,
1334: -- mtl_system_items MTLSI,
1335: xla_distribution_links XDL,
1336: xla_ae_lines XAL,
1337: ap_acct_class_code_gt AAGT ,
1338: xla_ae_headers XAH,
1339: ap_alc_ledger_gt ALGT
1340: WHERE APIDG.po_distribution_id = POD.po_distribution_id(+)
1341: AND API.invoice_id = APIL.invoice_id
1795: xla_distribution_links XDL,
1796: xla_ae_headers XAH,
1797: xla_ae_lines XAL,
1798: ap_alc_ledger_gt ALGT,
1799: ap_acct_class_code_gt AAGT,
1800: ap_lookup_codes APL -- bug 8927096: add
1801: WHERE /*APIP.invoice_payment_id = l_invoice_pay_id --Bug 12703009 commented the extra filter as we no more use the cursor
1802: AND */ APIP.accounting_event_id = APHD.accounting_event_id --Bug 12703009 added extra join condition as per bug 5461146
1803: AND APIP.invoice_payment_id = APHD.invoice_payment_id