DBA Data[Home] [Help]

APPS.MRP_SOURCING_GRP dependencies on FINANCIALS_SYSTEM_PARAMETERS

Line 146: financials_system_parameters fsp

142: INTO var_source_org,
143: var_source_sub
144: FROM mtl_item_sub_inventories misi,
145: org_organization_definitions ood,
146: financials_system_parameters fsp
147: WHERE misi.organization_id = p_dest_organization_id
148: AND misi.inventory_item_id = p_item_id
149: AND misi.secondary_inventory = p_dest_subinventory
150: AND misi.organization_id = ood.organization_id

Line 193: financials_system_parameters fsp

189: INTO var_source_org,
190: var_source_sub
191: FROM mtl_secondary_inventories msi,
192: org_organization_definitions ood,
193: financials_system_parameters fsp
194: WHERE msi.organization_id = p_dest_organization_id
195: AND msi.secondary_inventory_name = p_dest_subinventory
196: AND msi.organization_id = ood.organization_id
197: AND ood.set_of_books_id = fsp.set_of_books_id

Line 241: financials_system_parameters fsp

237: INTO var_source_org,
238: var_source_sub
239: FROM mtl_system_items msi,
240: org_organization_definitions ood,
241: financials_system_parameters fsp
242: WHERE msi.organization_id = p_dest_organization_id
243: AND msi.inventory_item_id = p_item_id
244: AND msi.organization_id = ood.organization_id
245: AND ood.operating_unit = fsp.org_id -- bug 4968383

Line 286: financials_system_parameters fsp

282: INTO var_source_org,
283: var_source_sub
284: FROM mtl_parameters mp,
285: org_organization_definitions ood,
286: financials_system_parameters fsp
287: WHERE mp.organization_id = p_dest_organization_id
288: AND mp.organization_id = ood.organization_id
289: AND ood.operating_unit = fsp.org_id -- bug 4968383
290: AND ood.set_of_books_id = fsp.set_of_books_id;