APPS.MRP_RELEASE_PK dependencies on STANDARD

Line 13: STANDARD_ITEM CONSTANT INTEGER := 4;

9: MAKE CONSTANT INTEGER := 1;
10: BUY CONSTANT INTEGER := 2;
11: PLANNED_ORDER CONSTANT INTEGER := 5;
12: UNRELEASED_NO_CHARGES CONSTANT INTEGER := 1;
13: STANDARD_ITEM CONSTANT INTEGER := 4;
14: NO_AUTO_RELEASE CONSTANT INTEGER := 5;
15: NO_KANBAN_RELEASE CONSTANT INTEGER := 6;
16:
17: MRP_PLAN CONSTANT INTEGER := 1;

Line 156: AND msi.bom_item_type = STANDARD_ITEM

152: AND mr.new_order_placement_date BETWEEN TRUNC(var_start_date)
153: AND cal2.calendar_date
154: AND msi.organization_id = mr.organization_id
155: AND msi.inventory_item_id = mr.inventory_item_id
156: AND msi.bom_item_type = STANDARD_ITEM
157: AND NVL(msi.release_time_fence_code, NO_AUTO_RELEASE) NOT IN
158: (NO_AUTO_RELEASE, NO_KANBAN_RELEASE)
159: AND ((msi.build_in_wip_flag = 'Y'
160: AND NVL(msi.repetitive_planning_flag, 'N') = 'N'