APPS.PO_ORGS_SV dependencies on MTL_SYSTEM_ITEMS

Line 115: FROM mtl_system_items msi

111:
112: IF ( x_item_id is not null ) THEN
113: SELECT count(1)
114: INTO x_org_count
115: FROM mtl_system_items msi
116: WHERE msi.inventory_item_id = x_item_id
117: AND msi.stock_enabled_flag = 'Y'
118: AND msi.purchasing_enabled_flag = 'Y'
119: AND msi.organization_id = x_org_id;

Line 124: FROM mtl_system_items msi

120:
121: ELSE
122: SELECT count(1)
123: INTO x_org_count
124: FROM mtl_system_items msi
125: WHERE msi.stock_enabled_flag = 'Y'
126: AND msi.purchasing_enabled_flag = 'Y'
127: AND msi.organization_id = x_org_id
128: AND ROWNUM < 2;

Line 145: FROM mtl_system_items msi

141:
142: IF ( x_item_id is not null ) THEN
143: SELECT count(1)
144: INTO x_org_count
145: FROM mtl_system_items msi
146: WHERE msi.inventory_item_id = x_item_id
147: AND msi.organization_id = x_org_id;
148: ELSE
149: SELECT count(1)

Line 151: FROM mtl_system_items msi

147: AND msi.organization_id = x_org_id;
148: ELSE
149: SELECT count(1)
150: INTO x_org_count
151: FROM mtl_system_items msi
152: WHERE msi.organization_id = x_org_id
153: AND ROWNUM < 2;
154: END IF;
155:

Line 170: FROM mtl_system_items msi

166:
167: IF ( x_item_id is not null ) THEN
168: SELECT count(1)
169: INTO x_org_count
170: FROM mtl_system_items msi
171: WHERE msi.inventory_item_id = x_item_id
172: AND msi.organization_id = x_org_id
173: AND msi.outside_operation_flag = 'Y';
174: ELSE

Line 177: FROM mtl_system_items msi

173: AND msi.outside_operation_flag = 'Y';
174: ELSE
175: SELECT count(1)
176: INTO x_org_count
177: FROM mtl_system_items msi
178: WHERE msi.organization_id = x_org_id
179: AND msi.outside_operation_flag = 'Y'
180: AND ROWNUM < 2;
181:

Line 308: FROM mtl_system_items msi

304: x_progress := '020';
305:
306: SELECT count(1)
307: INTO x_org_count
308: FROM mtl_system_items msi
309: WHERE msi.organization_id = x_src_org_id
310: AND msi.inventory_item_id = x_item_id
311: AND msi.stock_enabled_flag = 'Y'
312: AND msi.internal_order_enabled_flag = 'Y';

Line 349: FROM mtl_system_items ms1,

345: */
346:
347: SELECT count(1)
348: INTO x_org_count
349: FROM mtl_system_items ms1,
350: mtl_system_items ms2
351: WHERE ms1.inventory_item_id = x_item_id
352: AND ms1.organization_id = x_src_org_id
353: AND ms2.inventory_item_id = x_item_id

Line 350: mtl_system_items ms2

346:
347: SELECT count(1)
348: INTO x_org_count
349: FROM mtl_system_items ms1,
350: mtl_system_items ms2
351: WHERE ms1.inventory_item_id = x_item_id
352: AND ms1.organization_id = x_src_org_id
353: AND ms2.inventory_item_id = x_item_id
354: AND ms2.organization_id = x_dest_org_id