APPS.PJM_PROJECT_LOCATOR dependencies on MTL_SYSTEM_ITEMS

Line 91: FROM mtl_system_items

87: subinv_mismatch EXCEPTION;
88:
89: CURSOR c1 IS
90: SELECT end_assembly_pegging_flag
91: FROM mtl_system_items
92: WHERE inventory_item_id = p_item_id
93: AND organization_id = p_organization_id;
94:
95: BEGIN

Line 515: from mtl_system_items

511: where organization_id = X_organization_id
512: and secondary_locator = X_locator_id
513: and exists (
514: select 'Locator restriction is on'
515: from mtl_system_items
516: where organization_id = msl.organization_id
517: and inventory_item_id = msl.inventory_item_id
518: and restrict_locators_code = 1);
519:

Line 662: FROM mtl_system_items

658:
659: CURSOR C_Peg_Flag ( C_organization_id NUMBER
660: , C_item_id NUMBER) IS
661: SELECT end_assembly_pegging_flag
662: FROM mtl_system_items
663: WHERE inventory_item_id = C_item_id
664: AND organization_id = C_organization_id;
665:
666: BEGIN

Line 1199: FROM mtl_system_items mtl,

1195: l_item_loc_control,
1196: l_item_loc_restrict,
1197: l_item_sub_restrict,
1198: l_org_loc_control
1199: FROM mtl_system_items mtl,
1200: mtl_parameters mp
1201: WHERE mtl.inventory_item_id = p_item_id
1202: AND mtl.organization_id = p_organization_id
1203: AND mtl.organization_id = mp.organization_id;