APPS.JL_CO_GL_NIT_MANAGEMENT dependencies on RCV_RECEIVING_SUB_LEDGER

Line 1299: RCV_RECEIVING_SUB_LEDGER*/

1295: PROCEDURE Generate_PO_trx
1296: (p_journal_rec IN journals%ROWTYPE ) IS
1297:
1298: /*BUG 9078068 : Cursor added to accomodate Cost Mgmt Trxs of type CST_WRITE_OFFS and
1299: RCV_RECEIVING_SUB_LEDGER*/
1300: CURSOR po_detail_lines IS
1301: SELECT jlcgn.nit_id,
1302: REPLACE(povapf.num_1099,'-'),
1303: povapf.vendor_name,

Line 1320: RCV_RECEIVING_SUB_LEDGER RCVSD,

1316: WHERE trunc(sysdate) BETWEEN effective_start_date AND effective_end_date) papf
1317: WHERE nvl(aps.employee_id, -99) = papf.person_id (+)) povapf,
1318: xla_ae_lines AEL,
1319: gl_import_references R,
1320: RCV_RECEIVING_SUB_LEDGER RCVSD,
1321: xla_distribution_links LNK
1322: WHERE povapf.vendor_id = poha.vendor_id
1323: AND REPLACE(povapf.num_1099,'-') = jlcgn.nit(+)
1324: AND R.je_header_id = p_journal_rec.je_header_id

Line 1331: AND LNK.SOURCE_DISTRIBUTION_TYPE = 'RCV_RECEIVING_SUB_LEDGER'

1327: AND AEL.application_id = 707
1328: AND AEL.ae_header_id = LNK.ae_header_id
1329: AND AEL.ae_line_num = LNK.ae_line_num
1330: AND LNK.application_id = 707
1331: AND LNK.SOURCE_DISTRIBUTION_TYPE = 'RCV_RECEIVING_SUB_LEDGER'
1332: AND LNK.SOURCE_DISTRIBUTION_ID_NUM_1 = RCVSD.RCV_SUB_LEDGER_ID
1333: AND RCVSD.reference3 = podis.PO_DISTRIBUTION_ID
1334: AND podis.po_header_id = poha.po_header_id
1335: