DBA Data[Home] [Help]

APPS.MRP_SOURCING_API_PK dependencies on FINANCIALS_SYSTEM_PARAMETERS

Line 132: financials_system_parameters fsp

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
136: and misi.organization_id = ood.organization_id

Line 178: financials_system_parameters fsp

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
182: and ood.set_of_books_id = fsp.set_of_books_id

Line 226: financials_system_parameters fsp

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
230: AND ood.operating_unit = fsp.org_id -- bug 4968383

Line 272: financials_system_parameters fsp

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
276: AND ood.set_of_books_id = fsp.set_of_books_id;