APPS.INV_INVLTATT_XMLP_PKG dependencies on MTL_PARAMETERS

Line 31: FROM mtl_parameters

27: BEGIN
28: --get src organization code
29: SELECT organization_code
30: into P_SRC_ORG_CODE
31: FROM mtl_parameters
32: WHERE organization_id = P_SOURCE_ORG;
33:
34: /*if the range of items are different, the range of lots will be ignored,
35: all available lot numbers will to be updated.*/

Line 45: from mtl_parameters

41: --get dest organization code
42: IF(nvl(P_DEST_ORG_LO,-1) <> -1) THEN
43: select organization_code
44: into P_DEST_ORG_CODE_LO
45: from mtl_parameters
46: where organization_id = P_DEST_ORG_LO;
47: END IF;
48: IF(nvl(P_DEST_ORG_HI,-1) <> -1) THEN
49: select organization_code

Line 51: from mtl_parameters

47: END IF;
48: IF(nvl(P_DEST_ORG_HI,-1) <> -1) THEN
49: select organization_code
50: into P_DEST_ORG_CODE_HI
51: from mtl_parameters
52: where organization_id = P_DEST_ORG_HI;
53: END IF;
54:
55: EXCEPTION

Line 216: AND exists(select 'x' from mtl_lot_numbers mln1,mtl_parameters mp

212: from mtl_system_items_b
213: where (organization_id = P_SOURCE_ORG)
214: and (segment1 >= nvl(P_ITEM_LO,segment1) and segment1<=nvl(P_ITEM_HI,segment1))
215: and (lot_control_code = 2))
216: AND exists(select 'x' from mtl_lot_numbers mln1,mtl_parameters mp
217: where mln1.organization_id = mp.organization_id
218: and mp.organization_id <> P_SOURCE_ORG
219: and mp.organization_code >= P_DEST_ORG_CODE_LO
220: and mp.organization_code <= nvl(P_DEST_ORG_CODE_HI,mp.organization_code)

Line 383: FROM mtl_lot_numbers mln,mtl_parameters mp

379: mln.n_attribute7,
380: mln.n_attribute8,
381: mln.n_attribute9,
382: mln.n_attribute10
383: FROM mtl_lot_numbers mln,mtl_parameters mp
384: WHERE mln.organization_id = mp.organization_id
385: AND mp.organization_id <> P_SOURCE_ORG
386: AND mp.organization_code >= P_DEST_ORG_CODE_LO
387: AND mp.organization_code <= nvl(P_DEST_ORG_CODE_HI,mp.organization_code)

Line 393: from mtl_system_items_b msib,mtl_parameters mp

389: AND mln.lot_number <= nvl(P_LOT_HI,mln.lot_number)
390: /*Item should be lot controlled,
391: Lot should exists in source and destination */
392: AND inventory_item_id in(select inventory_item_id
393: from mtl_system_items_b msib,mtl_parameters mp
394: where msib.organization_id = mp.organization_id
395: and mp.organization_id <> P_SOURCE_ORG
396: and mp.organization_code >= P_DEST_ORG_CODE_LO
397: and mp.organization_code <= nvl(P_DEST_ORG_CODE_HI,mp.organization_code)