[Home] [Help]
37: BEGIN
38: l_current_calling_sequence := P_calling_sequence||'->'||
39: 'Populate_Mass_Ledger_Gt';
40: --
41: l_debug_info := 'Populate AP_ALC_LEDGER_GT';
42: --
43: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
44: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);
45: END IF;
43: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
44: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);
45: END IF;
46: --
47: INSERT INTO AP_ALC_LEDGER_GT (
48: source_ledger_id,
49: ledger_id,
50: ledger_category_code,
51: org_id)
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
837: AND APIL.invoice_id = APIDG.invoice_id
838: AND APIL.line_number = APIDG.invoice_line_number
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
1342: AND APIL.invoice_id = APIDG.invoice_id
1343: AND APIL.line_number = APIDG.invoice_line_number
1794: --po_line_types_b POLT,
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