eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_XDOCK_PEGGING_PUB dependencies on MTL_UNITS_OF_MEASURE

Line 1773: po_distributions_all pod, po_line_types plt, mtl_units_of_measure muom

1769: MIN(pod.project_id) AS project_id,
1770: MIN(pod.task_id) AS task_id,
1771: NULL AS lpn_id
1772: FROM po_headers_all poh, po_lines_all pol, po_line_locations_all poll,
1773: po_distributions_all pod, po_line_types plt, mtl_units_of_measure muom
1774: WHERE poh.type_lookup_code IN ('STANDARD','PLANNED','BLANKET','CONTRACT')
1775: AND NVL(poh.cancel_flag, 'N') IN ('N', 'I')
1776: AND NVL(poh.closed_code, 'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING','CLOSED')
1777: AND pol.po_header_id = poh.po_header_id

Line 1829: po_line_locations_all poll, po_distributions_all pod, mtl_units_of_measure muom

1825: MIN(pod.project_id) AS project_id,
1826: MIN(pod.task_id) AS task_id,
1827: NULL AS lpn_id
1828: FROM rcv_shipment_headers rsh, rcv_shipment_lines rsl, po_lines_all pol, po_line_types plt,
1829: po_line_locations_all poll, po_distributions_all pod, mtl_units_of_measure muom
1830: WHERE rsh.shipment_num IS NOT NULL
1831: AND rsh.receipt_source_code = 'VENDOR'
1832: AND rsh.asn_type in ('ASN','ASBN')
1833: AND rsh.shipment_header_id = rsl.shipment_header_id

Line 1885: mtl_units_of_measure muom

1881: MIN(prd.task_id) AS task_id,
1882: NULL AS lpn_id
1883: FROM po_requisition_headers_all prh, po_requisition_lines_all prl,
1884: rcv_shipment_lines rsl, rcv_shipment_headers rsh, po_req_distributions_all prd,
1885: mtl_units_of_measure muom
1886: WHERE prh.requisition_header_id = prl.requisition_header_id
1887: AND prd.requisition_line_id = prl.requisition_line_id
1888: AND prh.authorization_status = 'APPROVED'
1889: AND NVL(prl.cancel_flag,'N') = 'N'

Line 1927: po_req_distributions_all prd, mtl_interorg_parameters mip, mtl_units_of_measure muom

1923: MIN(prd.project_id) AS project_id,
1924: MIN(prd.task_id) AS task_id,
1925: NULL AS lpn_id
1926: FROM po_requisition_headers_all prh, po_requisition_lines_all prl,
1927: po_req_distributions_all prd, mtl_interorg_parameters mip, mtl_units_of_measure muom
1928: WHERE prh.requisition_header_id = prl.requisition_header_id
1929: AND prd.requisition_line_id = prl.requisition_line_id
1930: AND prh.authorization_status = 'APPROVED'
1931: AND NVL(prl.cancel_flag,'N') = 'N'

Line 1970: FROM rcv_shipment_headers rsh, rcv_shipment_lines rsl, mtl_units_of_measure muom

1966: NULL AS secondary_uom_code,
1967: NULL AS project_id,
1968: NULL AS task_id,
1969: NULL AS lpn_id
1970: FROM rcv_shipment_headers rsh, rcv_shipment_lines rsl, mtl_units_of_measure muom
1971: WHERE rsh.shipment_num IS NOT NULL
1972: AND rsh.shipment_header_id = rsl.shipment_header_id
1973: AND rsh.receipt_source_code = 'INVENTORY'
1974: AND EXISTS (SELECT 'Available Supply'

Line 2212: FROM po_line_locations_all poll, mtl_units_of_measure muom,

2208:
2209: -- Cursor to lock the PO supply line record.
2210: CURSOR lock_po_record(p_uom_code VARCHAR2, p_project_id NUMBER, p_task_id NUMBER) IS
2211: SELECT muom.uom_code, pod.project_id, pod.task_id
2212: FROM po_line_locations_all poll, mtl_units_of_measure muom,
2213: (SELECT po_header_id, po_line_id, line_location_id,
2214: MIN(project_id) AS project_id, MIN(task_id) AS task_id
2215: FROM po_distributions_all
2216: WHERE po_header_id = l_supply_header_id

Line 2237: FROM rcv_shipment_lines rsl, po_line_locations_all poll, mtl_units_of_measure muom,

2233:
2234: -- Cursor to lock the ASN supply line record.
2235: CURSOR lock_asn_record(p_uom_code VARCHAR2, p_project_id NUMBER, p_task_id NUMBER) IS
2236: SELECT muom.uom_code, pod.project_id, pod.task_id
2237: FROM rcv_shipment_lines rsl, po_line_locations_all poll, mtl_units_of_measure muom,
2238: (SELECT po_header_id, po_line_id, line_location_id,
2239: MIN(project_id) AS project_id, MIN(task_id) AS task_id
2240: FROM po_distributions_all
2241: WHERE po_header_id = l_supply_header_id

Line 2268: FROM po_requisition_lines_all prl, rcv_shipment_lines rsl, mtl_units_of_measure muom_prl,

2264: -- For UOM integrity, if we want to match the UOM from the supply to the reservation,
2265: -- just use the UOM at the requisition line level.
2266: CURSOR lock_intreq_record(p_uom_code VARCHAR2, p_project_id NUMBER, p_task_id NUMBER) IS
2267: SELECT muom_prl.uom_code, prd.project_id, prd.task_id
2268: FROM po_requisition_lines_all prl, rcv_shipment_lines rsl, mtl_units_of_measure muom_prl,
2269: (SELECT requisition_line_id, MIN(project_id) AS project_id, MIN(task_id) AS task_id
2270: FROM po_req_distributions_all
2271: WHERE requisition_line_id = l_supply_line_id
2272: GROUP BY requisition_line_id

Line 2290: FROM rcv_shipment_lines rsl, mtl_units_of_measure muom

2286:
2287: -- Cursor to lock the In Transit Shipment supply line record.
2288: CURSOR lock_intship_record(p_uom_code VARCHAR2, p_project_id NUMBER, p_task_id NUMBER) IS
2289: SELECT muom.uom_code, NULL AS project_id, NULL AS task_id
2290: FROM rcv_shipment_lines rsl, mtl_units_of_measure muom
2291: WHERE rsl.shipment_header_id = l_supply_header_id
2292: AND rsl.shipment_line_id = l_supply_line_id
2293: AND rsl.unit_of_measure = muom.unit_of_measure
2294: AND (p_uom_code IS NULL OR muom.uom_code = p_uom_code)

Line 3084: FROM mtl_units_of_measure

3080: IF (NOT l_uom_class_tb.EXISTS(l_demand_uom_code)) THEN
3081: BEGIN
3082: SELECT uom_class
3083: INTO l_uom_class_tb(l_demand_uom_code)
3084: FROM mtl_units_of_measure
3085: WHERE uom_code = l_demand_uom_code;
3086: EXCEPTION
3087: WHEN OTHERS THEN
3088: IF (l_debug = 1) THEN