APPS.WIP_WOL_PROCESSOR dependencies on MTL_SYSTEM_ITEMS

Line 26: FROM mtl_system_items msi

22: AND p_header_id <> header_id
23: AND bom_revision IS NULL
24: AND EXISTS (
25: SELECT 'X'
26: FROM mtl_system_items msi
27: WHERE msi.organization_id = wlc.organization_id
28: AND msi.inventory_item_id = wlc.inventory_item_id
29: AND msi.revision_qty_control_code = 2);
30: END deriveItemRevision;

Line 43: FROM mtl_system_items msi

39: AND source_id <> header_id
40: AND ((bom_revision is not null
41: AND ( (EXISTS (
42: SELECT 'item is under revision control'
43: FROM mtl_system_items msi
44: WHERE msi.organization_id = wlc.organization_id
45: AND msi.inventory_item_id = wlc.inventory_item_id
46: AND msi.revision_qty_control_code = 2)
47: AND NOT EXISTS (

Line 57: FROM mtl_system_items msi

53: AND bbrrv.effectivity_date <= SYSDATE))
54: OR
55: (EXISTS (
56: SELECT 'item is not under revision control'
57: FROM mtl_system_items msi
58: WHERE msi.organization_id = wlc.organization_id
59: AND msi.inventory_item_id = wlc.inventory_item_id
60: AND msi.revision_qty_control_code = 1))))
61: OR

Line 65: FROM mtl_system_items msi

61: OR
62: (bom_revision IS NULL
63: AND (EXISTS (
64: SELECT 'item is under revision control'
65: FROM mtl_system_items msi
66: WHERE msi.organization_id = wlc.organization_id
67: AND msi.inventory_item_id = wlc.inventory_item_id
68: AND msi.revision_qty_control_code = 2)
69: AND NOT EXISTS (

Line 93: FROM mtl_system_items

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