DBA Data[Home] [Help]

APPS.PO_ORGS_SV2 dependencies on MTL_SYSTEM_ITEMS

Line 64: FROM mtl_system_items msi

60: x_progress := '020';
61:
62: SELECT count(1)
63: INTO x_org_count
64: FROM mtl_system_items msi
65: WHERE msi.organization_id = x_destination_org_id
66: AND msi.inventory_item_id = x_item_id
67: AND msi.stock_enabled_flag = 'Y'
68: AND decode(x_source_type, 'VENDOR', 'Y',

Line 90: FROM mtl_system_items msi

86: x_progress := '040';
87:
88: SELECT count(1)
89: INTO x_org_count
90: FROM mtl_system_items msi
91: WHERE msi.organization_id = x_destination_org_id
92: AND msi.inventory_item_id = x_item_id
93: AND decode(x_source_type, 'VENDOR', 'Y',
94: msi.purchasing_enabled_flag) = msi.purchasing_enabled_flag;

Line 106: FROM mtl_system_items msi

102: x_progress := '030';
103:
104: SELECT count(1)
105: INTO x_org_count
106: FROM mtl_system_items msi
107: WHERE msi.inventory_item_id = x_item_id
108: AND msi.organization_id = x_destination_org_id
109: AND msi.purchasing_enabled_flag = 'Y'
110: AND msi.outside_operation_flag = 'Y';

Line 172: mtl_system_items msi,

168:
169: SELECT mip.intransit_type
170: INTO x_intransit_type
171: FROM org_organization_definitions ood,
172: mtl_system_items msi,
173: mtl_interorg_parameters mip
174: WHERE ood.organization_id = x_source_org_id
175: AND sysdate < nvl(ood.disable_date, sysdate + 1)
176: AND mip.from_organization_id = x_source_org_id

Line 217: FROM mtl_system_items msi1,

213: */
214:
215: SELECT count(1)
216: INTO x_org_count
217: FROM mtl_system_items msi1,
218: mtl_system_items msi2
219: WHERE msi1.inventory_item_id = x_item_id
220: AND msi1.organization_id = x_source_org_id
221: AND msi2.inventory_item_id = x_item_id

Line 218: mtl_system_items msi2

214:
215: SELECT count(1)
216: INTO x_org_count
217: FROM mtl_system_items msi1,
218: mtl_system_items msi2
219: WHERE msi1.inventory_item_id = x_item_id
220: AND msi1.organization_id = x_source_org_id
221: AND msi2.inventory_item_id = x_item_id
222: AND msi2.organization_id = x_destination_org_id

Line 246: mtl_system_items msi

242:
243: SELECT 'Y'
244: INTO l_internal_ordered
245: FROM org_organization_definitions ood,
246: mtl_system_items msi
247: WHERE ood.organization_id = x_source_org_id
248: AND sysdate < nvl(ood.disable_date, sysdate + 1)
249: AND msi.organization_id = x_source_org_id
250: AND msi.inventory_item_id = x_item_id