DBA Data[Home] [Help]

APPS.PO_REQCHANGEREQUESTNOTIF_PVT dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 2509: financials_system_params_all fsp

2505: begin
2506: select msi.concatenated_segments
2507: into l_item
2508: from mtl_system_items_kfv msi,
2509: financials_system_params_all fsp
2510: where msi.inventory_item_id=l_item_id
2511: and fsp.INVENTORY_ORGANIZATION_ID =
2512: NVL(MSI.ORGANIZATION_ID, FSP.INVENTORY_ORGANIZATION_ID)
2513: and fsp.org_id=l_org_id;

Line 2638: financials_system_params_all fsp

2634: begin
2635: select msi.concatenated_segments
2636: into l_item
2637: from mtl_system_items_kfv msi,
2638: financials_system_params_all fsp
2639: where msi.inventory_item_id=l_item_id
2640: and fsp.INVENTORY_ORGANIZATION_ID =
2641: NVL(MSI.ORGANIZATION_ID, FSP.INVENTORY_ORGANIZATION_ID)
2642: and fsp.org_id=l_org_id;

Line 4462: FROM gl_sets_of_books sob, financials_system_params_all fsp

4458: l_progress := '002';
4459:
4460: SELECT sob.currency_code
4461: INTO l_functional_currency_code
4462: FROM gl_sets_of_books sob, financials_system_params_all fsp
4463: WHERE fsp.org_id = p_org_id
4464: AND fsp.set_of_books_id = sob.set_of_books_id;
4465:
4466: l_progress := '003';