DBA Data[Home] [Help]

APPS.RCV_EXPRESS_SV dependencies on MTL_PARAMETERS

Line 1292: l_mp_lcm_flag mtl_parameters.lcm_enabled_flag%TYPE; -- Bug 9575796

1288: x_locator_id NUMBER;
1289: l_project_locator_id number;
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

Line 1342: mtl_parameters mp,

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
1346: AND mp.organization_id = rp.organization_id;