DBA Data[Home] [Help]

APPS.RCV_EXPRESS_SV dependencies on PO_LINE_LOCATIONS_ALL

Line 1294: l_pll_lcm_flag po_line_locations_all.lcm_flag%TYPE; -- Bug 9575796

1290: l_locator_id number;
1291:
1292: l_mp_lcm_flag mtl_parameters.lcm_enabled_flag%TYPE; -- Bug 9575796
1293: l_pre_receive_flag rcv_parameters.pre_receive%TYPE; -- Bug 9575796
1294: l_pll_lcm_flag po_line_locations_all.lcm_flag%TYPE; -- Bug 9575796
1295:
1296: BEGIN
1297:
1298: /*

Line 1341: FROM po_line_locations_all pll,

1337: -- Bug 9575796 : Start
1338: IF (rcv_trx.source_document_code = 'PO' and rcv_trx.po_line_location_id is not null) THEN
1339: SELECT nvl(mp.lcm_enabled_flag,'N'), nvl(rp.pre_receive,'N'),nvl(pll.lcm_flag,'N')
1340: INTO l_mp_lcm_flag, l_pre_receive_flag, l_pll_lcm_flag
1341: FROM po_line_locations_all pll,
1342: mtl_parameters mp,
1343: rcv_parameters rp
1344: WHERE pll.line_location_id = rcv_trx.po_line_location_id
1345: AND mp.organization_id = rcv_trx.to_organization_id