APPS.PO_GA_PVT dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 713: financials_system_params_all FSP1,

709: l_osp_flag,
710: l_uom_class,
711: l_valid_uom_class
712: FROM
713: financials_system_params_all FSP1,
714: financials_system_params_all FSP2, -- valid org
715: mtl_system_items_b ITEMS1,
716: mtl_system_items_b ITEMS2, -- valid org
717: mtl_units_of_measure_tl UOM1,

Line 714: financials_system_params_all FSP2, -- valid org

710: l_uom_class,
711: l_valid_uom_class
712: FROM
713: financials_system_params_all FSP1,
714: financials_system_params_all FSP2, -- valid org
715: mtl_system_items_b ITEMS1,
716: mtl_system_items_b ITEMS2, -- valid org
717: mtl_units_of_measure_tl UOM1,
718: mtl_units_of_measure_tl UOM2 -- valid org

Line 1497: FROM financials_system_params_all fspa_ga, -- GA owning org

1493: --SQL Why: Validate that p_org_id can source p_ga_item_revision from
1494: -- p_owning_org_id
1495: SELECT mir_ga.revision
1496: INTO x_item_revision
1497: FROM financials_system_params_all fspa_ga, -- GA owning org
1498: financials_system_params_all fspa,
1499: mtl_item_revisions_b mir_ga, -- GA revision
1500: mtl_item_revisions_b mir
1501: WHERE fspa_ga.org_id = p_owning_org_id

Line 1498: financials_system_params_all fspa,

1494: -- p_owning_org_id
1495: SELECT mir_ga.revision
1496: INTO x_item_revision
1497: FROM financials_system_params_all fspa_ga, -- GA owning org
1498: financials_system_params_all fspa,
1499: mtl_item_revisions_b mir_ga, -- GA revision
1500: mtl_item_revisions_b mir
1501: WHERE fspa_ga.org_id = p_owning_org_id
1502: AND mir_ga.organization_id = fspa_ga.inventory_organization_id

Line 1534: FROM financials_system_params_all fspa_ga, -- GA owning org

1530: -- p_ga_item_revision exists in p_owning_org_id
1531: --SQL Why: Check if p_org_id can still source the item revision
1532: SELECT NVL(msi.revision_qty_control_code, 1)
1533: INTO l_rev_control
1534: FROM financials_system_params_all fspa_ga, -- GA owning org
1535: financials_system_params_all fspa,
1536: mtl_item_revisions_b mir_ga, -- GA revision
1537: mtl_system_items_b msi
1538: WHERE fspa_ga.org_id = p_owning_org_id

Line 1535: financials_system_params_all fspa,

1531: --SQL Why: Check if p_org_id can still source the item revision
1532: SELECT NVL(msi.revision_qty_control_code, 1)
1533: INTO l_rev_control
1534: FROM financials_system_params_all fspa_ga, -- GA owning org
1535: financials_system_params_all fspa,
1536: mtl_item_revisions_b mir_ga, -- GA revision
1537: mtl_system_items_b msi
1538: WHERE fspa_ga.org_id = p_owning_org_id
1539: AND mir_ga.organization_id = fspa_ga.inventory_organization_id