APPS.PJM_PROJECT_LOCATOR dependencies on MTL_SYSTEM_ITEMS

Line 90: FROM mtl_system_items

86: l_peg_flag VARCHAR2(1) := NULL;
87:
88: CURSOR c1 IS
89: SELECT end_assembly_pegging_flag
90: FROM mtl_system_items
91: WHERE inventory_item_id = p_item_id
92: AND organization_id = p_organization_id;
93:
94: BEGIN

Line 500: from mtl_system_items

496: where organization_id = X_organization_id
497: and secondary_locator = X_locator_id
498: and exists (
499: select 'Locator restriction is on'
500: from mtl_system_items
501: where organization_id = msl.organization_id
502: and inventory_item_id = msl.inventory_item_id
503: and restrict_locators_code = 1);
504:

Line 1144: FROM mtl_system_items mtl,

1140: l_item_loc_control,
1141: l_item_loc_restrict,
1142: l_item_sub_restrict,
1143: l_org_loc_control
1144: FROM mtl_system_items mtl,
1145: mtl_parameters mp
1146: WHERE mtl.inventory_item_id = p_item_id
1147: AND mtl.organization_id = p_organization_id
1148: AND mtl.organization_id = mp.organization_id;