APPS.MRP_SOURCING_API_PK dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 131: org_organization_definitions ood,

127: misi.source_subinventory
128: into var_source_org,
129: var_source_sub
130: from mtl_item_sub_inventories misi,
131: org_organization_definitions ood,
132: financials_system_parameters fsp
133: where misi.organization_id = arg_dest_organization_id
134: and misi.inventory_item_id = arg_item_id
135: and misi.secondary_inventory = arg_dest_subinventory

Line 177: org_organization_definitions ood,

173: msi.source_subinventory
174: into var_source_org,
175: var_source_sub
176: from mtl_secondary_inventories msi,
177: org_organization_definitions ood,
178: financials_system_parameters fsp
179: where msi.organization_id = arg_dest_organization_id
180: and msi.secondary_inventory_name = arg_dest_subinventory
181: and msi.organization_id = ood.organization_id

Line 225: org_organization_definitions ood,

221: msi.source_subinventory
222: INTO var_source_org,
223: var_source_sub
224: FROM mtl_system_items msi,
225: org_organization_definitions ood,
226: financials_system_parameters fsp
227: WHERE msi.organization_id = arg_dest_organization_id
228: AND msi.inventory_item_id = arg_item_id
229: AND msi.organization_id = ood.organization_id

Line 271: org_organization_definitions ood,

267: mp.source_subinventory
268: INTO var_source_org,
269: var_source_sub
270: FROM mtl_parameters mp,
271: org_organization_definitions ood,
272: financials_system_parameters fsp
273: WHERE mp.organization_id = arg_dest_organization_id
274: AND mp.organization_id = ood.organization_id
275: AND ood.operating_unit = fsp.org_id -- bug 4968383

Line 441: FROM org_organization_definitions oog,

437: THEN
438: IF var_vendor_site_code IS NOT NULL THEN
439: select dest_site.vendor_site_id
440: into arg_vendor_site_id
441: FROM org_organization_definitions oog,
442: po_vendor_sites_all dest_site,
443: po_vendors ven
444: WHERE NVL(ven.enabled_flag, 'N') = 'Y'
445: AND sysdate BETWEEN NVL(ven.start_date_active, sysdate -1)