670: x_is_same_uom_class OUT NOCOPY BOOLEAN,
671: x_is_not_osp_item OUT NOCOPY BOOLEAN
672: )
673: IS
674: l_purchasable_flag MTL_SYSTEM_ITEMS_B.purchasing_enabled_flag%TYPE;
675: l_osp_flag MTL_SYSTEM_ITEMS_B.outside_operation_flag%TYPE;
676: l_uom_class MTL_UNITS_OF_MEASURE_TL.uom_class%TYPE;
677: l_valid_uom_class MTL_UNITS_OF_MEASURE_TL.uom_class%TYPE;
678: l_progress VARCHAR2(3);
671: x_is_not_osp_item OUT NOCOPY BOOLEAN
672: )
673: IS
674: l_purchasable_flag MTL_SYSTEM_ITEMS_B.purchasing_enabled_flag%TYPE;
675: l_osp_flag MTL_SYSTEM_ITEMS_B.outside_operation_flag%TYPE;
676: l_uom_class MTL_UNITS_OF_MEASURE_TL.uom_class%TYPE;
677: l_valid_uom_class MTL_UNITS_OF_MEASURE_TL.uom_class%TYPE;
678: l_progress VARCHAR2(3);
679:
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
719: WHERE
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
719: WHERE
720: FSP1.org_id = p_org_id
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
1540: AND mir_ga.inventory_item_id = p_item_id
1541: AND mir_ga.revision = p_ga_item_revision