APPS.JMF_SHIKYU_ALLOCATION_PVT dependencies on MTL_UNITS_OF_MEASURE_VL

Line 1240: l_primary_uom MTL_UNITS_OF_MEASURE_VL.uom_code%TYPE;

1236:
1237: l_api_name CONSTANT VARCHAR2(30) := 'Get_Available_Replenishment_Po';
1238: l_api_version CONSTANT NUMBER := 1.0;
1239:
1240: l_primary_uom MTL_UNITS_OF_MEASURE_VL.uom_code%TYPE;
1241: l_replen_po_primary_uom MTL_UNITS_OF_MEASURE_VL.uom_code%TYPE;
1242:
1243: l_oem_organization_id JMF_SUBCONTRACT_ORDERS.oem_organization_id%TYPE;
1244: l_tp_organization_id JMF_SUBCONTRACT_ORDERS.tp_organization_id%TYPE;

Line 1241: l_replen_po_primary_uom MTL_UNITS_OF_MEASURE_VL.uom_code%TYPE;

1237: l_api_name CONSTANT VARCHAR2(30) := 'Get_Available_Replenishment_Po';
1238: l_api_version CONSTANT NUMBER := 1.0;
1239:
1240: l_primary_uom MTL_UNITS_OF_MEASURE_VL.uom_code%TYPE;
1241: l_replen_po_primary_uom MTL_UNITS_OF_MEASURE_VL.uom_code%TYPE;
1242:
1243: l_oem_organization_id JMF_SUBCONTRACT_ORDERS.oem_organization_id%TYPE;
1244: l_tp_organization_id JMF_SUBCONTRACT_ORDERS.tp_organization_id%TYPE;
1245:

Line 1274: mtl_units_of_measure_vl muomv

1270: hr_organization_information hoi,
1271: po_line_locations_all plla,
1272: po_lines_all pla,
1273: po_headers_all pha,
1274: mtl_units_of_measure_vl muomv
1275: WHERE jso.subcontract_po_shipment_id = p_subcontract_po_shipment_id
1276: AND hoi.organization_id = jso.oem_organization_id
1277: AND hoi.org_information_context = 'Customer/Supplier Association'
1278: AND TO_NUMBER(hoi.org_information3) = pha.vendor_id

Line 3703: MTL_UNITS_OF_MEASURE_VL.uom_code%TYPE;

3699: l_msg_data VARCHAR2(300);
3700: l_header_id NUMBER;
3701: l_primary_uom_qty NUMBER;
3702: l_uom
3703: MTL_UNITS_OF_MEASURE_VL.uom_code%TYPE;
3704: l_primary_uom
3705: MTL_UNITS_OF_MEASURE_VL.uom_code%TYPE;
3706:
3707: l_reduced_allocations_tbl

Line 3705: MTL_UNITS_OF_MEASURE_VL.uom_code%TYPE;

3701: l_primary_uom_qty NUMBER;
3702: l_uom
3703: MTL_UNITS_OF_MEASURE_VL.uom_code%TYPE;
3704: l_primary_uom
3705: MTL_UNITS_OF_MEASURE_VL.uom_code%TYPE;
3706:
3707: l_reduced_allocations_tbl
3708: JMF_SHIKYU_ALLOCATION_PVT.g_allocation_qty_tbl_type;
3709: