APPS.JMF_SHIKYU_ALLOCATION_PVT dependencies on MTL_UNITS_OF_MEASURE_VL

Line 1244: l_primary_uom MTL_UNITS_OF_MEASURE_VL.uom_code%TYPE;

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

Line 1245: l_replen_po_primary_uom MTL_UNITS_OF_MEASURE_VL.uom_code%TYPE;

1241: l_api_name CONSTANT VARCHAR2(30) := 'Get_Available_Replenishment_Po';
1242: l_api_version CONSTANT NUMBER := 1.0;
1243:
1244: l_primary_uom MTL_UNITS_OF_MEASURE_VL.uom_code%TYPE;
1245: l_replen_po_primary_uom MTL_UNITS_OF_MEASURE_VL.uom_code%TYPE;
1246:
1247: l_oem_organization_id JMF_SUBCONTRACT_ORDERS.oem_organization_id%TYPE;
1248: l_tp_organization_id JMF_SUBCONTRACT_ORDERS.tp_organization_id%TYPE;
1249:

Line 1278: mtl_units_of_measure_vl muomv

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

Line 4024: MTL_UNITS_OF_MEASURE_VL.uom_code%TYPE;

4020: l_msg_data VARCHAR2(300);
4021: l_header_id NUMBER;
4022: l_primary_uom_qty NUMBER;
4023: l_uom
4024: MTL_UNITS_OF_MEASURE_VL.uom_code%TYPE;
4025: l_primary_uom
4026: MTL_UNITS_OF_MEASURE_VL.uom_code%TYPE;
4027:
4028: l_reduced_allocations_tbl

Line 4026: MTL_UNITS_OF_MEASURE_VL.uom_code%TYPE;

4022: l_primary_uom_qty NUMBER;
4023: l_uom
4024: MTL_UNITS_OF_MEASURE_VL.uom_code%TYPE;
4025: l_primary_uom
4026: MTL_UNITS_OF_MEASURE_VL.uom_code%TYPE;
4027:
4028: l_reduced_allocations_tbl
4029: JMF_SHIKYU_ALLOCATION_PVT.g_allocation_qty_tbl_type;
4030: