APPS.POS_CHANGE_PROM_DATES dependencies on MTL_SYSTEM_ITEMS

Line 891: from mtl_system_items

887: begin
888:
889: select distinct planner_code
890: into x_planner_code
891: from mtl_system_items
892: where inventory_item_id = x_item_id
893: and organization_id = x_ship_to_org_id;
894:
895: x_progress := '002';

Line 1094: from mtl_system_items

1090: result := 'COMPLETE:N';
1091: ELSE
1092: select distinct OUTSIDE_OPERATION_FLAG
1093: into x_osp_item_flag
1094: from mtl_system_items
1095: where inventory_item_id = x_item_id
1096: and organization_id = x_ship_to_org_id;
1097:
1098: if nvl(x_osp_item_flag, 'N') = 'Y' then

Line 1140: from mtl_system_items

1136: result := 'COMPLETE:N';
1137: ELSE
1138: select distinct REPETITIVE_PLANNING_FLAG
1139: into x_planning_item_flag
1140: from mtl_system_items
1141: where inventory_item_id = x_item_id
1142: and organization_id = x_ship_to_org_id;
1143:
1144: if nvl(x_planning_item_flag, 'N') = 'Y' then