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_PACKING_WORKBENCH_PVT dependencies on RCV_SHIPMENT_LINES

Line 297: l_from_str := l_from_str || ' rcv_shipment_lines rsl,';

293: l_select_str := l_select_str || ' rs.unit_of_measure ';
294:
295: l_from_str := ' FROM rcv_supply rs,';
296: l_from_str := l_from_str || ' rcv_transactions rt,';
297: l_from_str := l_from_str || ' rcv_shipment_lines rsl,';
298: l_from_str := l_from_str || ' rcv_shipment_headers rsh';
299:
300: l_where_str := ' WHERE rs.supply_source_id = rt.transaction_id';
301: l_where_str := l_where_str || ' AND rs.to_organization_id = :org_id';

Line 929: l_where_str := l_where_str||' FROM rcv_shipment_lines rsl,rcv_shipment_headers rsh';

925: IF (p_receipt_number IS NOT NULL) THEN
926: l_receipt_used := 1;
927: l_where_str := l_where_str||' AND mol.inventory_item_id';
928: l_where_str := l_where_str||' IN (SELECT rsl.item_id';
929: l_where_str := l_where_str||' FROM rcv_shipment_lines rsl,rcv_shipment_headers rsh';
930: l_where_str := l_where_str||' WHERE rsh.receipt_num = :receipt_num';
931: l_where_str := l_where_str||' AND rsh.shipment_header_id = rsl.shipment_header_id)';
932: ELSIF (p_document_type = 'PO') THEN
933: IF (p_document_id IS NOT NULL AND p_document_line_id IS NOT NULL) THEN

Line 1379: FROM rcv_shipment_lines rsl, rcv_shipment_headers rsh

1375: IF l_material_rec.reference_id IS NOT NULL THEN
1376: BEGIN
1377: SELECT rsh.shipment_header_id, rsl.shipment_line_id, rsl.requisition_line_id, rsh.shipment_num, rsh.asn_type, rsh.receipt_source_code, rsh.ship_to_org_id, rsl.line_num, rsh.receipt_num, rsh.vendor_id, rsl.from_organization_id
1378: INTO l_shipment_header_id, l_shipment_line_id, l_req_line_id, l_shipment_num, l_asn_type, l_receipt_source_code, l_ship_to_org_id, l_line_num, l_receipt_num, l_vendor_id, l_src_org_id
1379: FROM rcv_shipment_lines rsl, rcv_shipment_headers rsh
1380: WHERE rsh.shipment_header_id = rsl.shipment_header_id
1381: AND rsl.shipment_line_id = l_material_rec.reference_id;
1382: EXCEPTION
1383: WHEN no_data_found THEN

Line 1442: FROM rcv_shipment_lines rsl, rcv_shipment_headers rsh

1438: BEGIN
1439: SELECT rsh.shipment_header_id, rsh.shipment_num, rsh.receipt_num,rsh.vendor_id
1440: ,rsl.shipment_line_id, rsl.line_num,rsl.from_organization_id
1441: INTO l_material_rec.document_id, l_material_rec.document_number, l_receipt_num, l_vendor_id,l_shipment_line_id, l_line_num, l_src_org_id
1442: FROM rcv_shipment_lines rsl, rcv_shipment_headers rsh
1443: WHERE rsh.shipment_header_id = rsl.shipment_header_id
1444: AND rsl.shipment_line_id = l_material_rec.reference_id;
1445: EXCEPTION
1446: WHEN no_data_found THEN

Line 1474: FROM rcv_shipment_lines rsl

1470: IF (l_material_rec.reference_id IS NOT NULL) THEN
1471: BEGIN
1472: SELECT rsl.shipment_line_id, rsl.line_num, rsl.from_organization_id
1473: INTO l_material_rec.document_line_id, l_material_rec.document_line_num, l_src_org_id
1474: FROM rcv_shipment_lines rsl
1475: WHERE rsl.shipment_line_id = l_material_rec.reference_id;
1476: EXCEPTION
1477: WHEN no_data_found THEN
1478: IF l_debug = 1 THEN

Line 1498: FROM rcv_shipment_lines rsl, rcv_shipment_headers rsh

1494: ELSE
1495: IF (l_material_rec.reference_id IS NOT NULL) THEN
1496: BEGIN
1497: SELECT rsh.vendor_id INTO l_material_rec.vendor_id
1498: FROM rcv_shipment_lines rsl, rcv_shipment_headers rsh
1499: WHERE rsh.shipment_header_id = rsl.shipment_header_id
1500: AND rsl.shipment_line_id = l_material_rec.reference_id;
1501: EXCEPTION
1502: WHEN no_data_found THEN

Line 1534: FROM rcv_shipment_lines rsl

1530: ELSE
1531: IF (l_material_rec.reference_id IS NOT NULL) THEN
1532: BEGIN
1533: SELECT rsl.from_organization_id INTO l_material_rec.source_org_id
1534: FROM rcv_shipment_lines rsl
1535: WHERE rsl.shipment_line_id = l_material_rec.reference_id;
1536: EXCEPTION
1537: WHEN no_data_found THEN
1538: IF l_debug = 1 THEN

Line 1639: FROM po_requisition_headers_all prh, po_requisition_lines_all prl, rcv_shipment_lines rsl

1635: BEGIN
1636: SELECT prh.requisition_header_id, prh.segment1, prl.requisition_line_id, prl.line_num
1637: INTO l_material_rec.document_id, l_material_rec.document_number
1638: , l_material_rec.document_line_id, l_material_rec.document_line_num
1639: FROM po_requisition_headers_all prh, po_requisition_lines_all prl, rcv_shipment_lines rsl
1640: WHERE rsl.shipment_line_id = l_material_rec.reference_id
1641: AND prh.requisition_header_id = prl.requisition_header_id
1642: AND prl.requisition_line_id = rsl.requisition_line_id;
1643: EXCEPTION

Line 1659: FROM po_requisition_lines_all prl, rcv_shipment_lines rsl

1655: IF (l_material_rec.reference_id IS NOT NULL) THEN
1656: BEGIN
1657: SELECT prl.requisition_line_id, prl.line_num
1658: INTO l_material_rec.document_line_id, l_material_rec.document_line_num
1659: FROM po_requisition_lines_all prl, rcv_shipment_lines rsl
1660: WHERE rsl.shipment_line_id = l_material_rec.reference_id
1661: AND prl.requisition_line_id = rsl.requisition_line_id;
1662: EXCEPTION
1663: WHEN no_data_found THEN