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,
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
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
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
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
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