APPS.PO_GA_PVT dependencies on MTL_SYSTEM_ITEMS

Line 674: l_purchasable_flag MTL_SYSTEM_ITEMS_B.purchasing_enabled_flag%TYPE;

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);

Line 675: l_osp_flag MTL_SYSTEM_ITEMS_B.outside_operation_flag%TYPE;

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:

Line 715: mtl_system_items_b ITEMS1,

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

Line 716: mtl_system_items_b ITEMS2, -- valid org

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

Line 1464: l_rev_control MTL_SYSTEM_ITEMS.revision_qty_control_code%TYPE;

1460: x_item_revision OUT NOCOPY VARCHAR2
1461: )
1462: IS
1463:
1464: l_rev_control MTL_SYSTEM_ITEMS.revision_qty_control_code%TYPE;
1465: l_progress VARCHAR2(3);
1466:
1467: BEGIN
1468: l_progress := '000';

Line 1537: mtl_system_items_b msi

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