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 281: l_from_str := l_from_str || ' rcv_shipment_lines rsl,';

277: l_select_str := l_select_str || ' rs.rcv_transaction_id';
278:
279: l_from_str := ' FROM rcv_supply rs,';
280: l_from_str := l_from_str || ' rcv_transactions rt,';
281: l_from_str := l_from_str || ' rcv_shipment_lines rsl,';
282: l_from_str := l_from_str || ' rcv_shipment_headers rsh';
283:
284: l_where_str := ' WHERE rs.supply_source_id = rt.transaction_id';
285: l_where_str := l_where_str || ' AND rs.to_organization_id = :org_id';

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

864: IF (p_receipt_number IS NOT NULL) THEN
865: l_receipt_used := 1;
866: l_where_str := l_where_str||' AND mol.inventory_item_id';
867: l_where_str := l_where_str||' IN (SELECT rsl.item_id';
868: l_where_str := l_where_str||' FROM rcv_shipment_lines rsl,rcv_shipment_headers rsh';
869: l_where_str := l_where_str||' WHERE rsh.receipt_num = :receipt_num';
870: l_where_str := l_where_str||' AND rsh.shipment_header_id = rsl.shipment_header_id)';
871: ELSIF (p_document_type = 'PO') THEN
872: IF (p_document_id IS NOT NULL AND p_document_line_id IS NOT NULL) THEN

Line 1316: FROM rcv_shipment_lines rsl, rcv_shipment_headers rsh

1312: IF l_material_rec.reference_id IS NOT NULL THEN
1313: BEGIN
1314: 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
1315: 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
1316: FROM rcv_shipment_lines rsl, rcv_shipment_headers rsh
1317: WHERE rsh.shipment_header_id = rsl.shipment_header_id
1318: AND rsl.shipment_line_id = l_material_rec.reference_id;
1319: EXCEPTION
1320: WHEN no_data_found THEN

Line 1379: FROM rcv_shipment_lines rsl, rcv_shipment_headers rsh

1375: BEGIN
1376: SELECT rsh.shipment_header_id, rsh.shipment_num, rsh.receipt_num,rsh.vendor_id
1377: ,rsl.shipment_line_id, rsl.line_num,rsl.from_organization_id
1378: 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
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 1411: FROM rcv_shipment_lines rsl

1407: IF (l_material_rec.reference_id IS NOT NULL) THEN
1408: BEGIN
1409: SELECT rsl.shipment_line_id, rsl.line_num, rsl.from_organization_id
1410: INTO l_material_rec.document_line_id, l_material_rec.document_line_num, l_src_org_id
1411: FROM rcv_shipment_lines rsl
1412: WHERE rsl.shipment_line_id = l_material_rec.reference_id;
1413: EXCEPTION
1414: WHEN no_data_found THEN
1415: IF l_debug = 1 THEN

Line 1435: FROM rcv_shipment_lines rsl, rcv_shipment_headers rsh

1431: ELSE
1432: IF (l_material_rec.reference_id IS NOT NULL) THEN
1433: BEGIN
1434: SELECT rsh.vendor_id INTO l_material_rec.vendor_id
1435: FROM rcv_shipment_lines rsl, rcv_shipment_headers rsh
1436: WHERE rsh.shipment_header_id = rsl.shipment_header_id
1437: AND rsl.shipment_line_id = l_material_rec.reference_id;
1438: EXCEPTION
1439: WHEN no_data_found THEN

Line 1471: FROM rcv_shipment_lines rsl

1467: ELSE
1468: IF (l_material_rec.reference_id IS NOT NULL) THEN
1469: BEGIN
1470: SELECT rsl.from_organization_id INTO l_material_rec.source_org_id
1471: FROM rcv_shipment_lines rsl
1472: WHERE rsl.shipment_line_id = l_material_rec.reference_id;
1473: EXCEPTION
1474: WHEN no_data_found THEN
1475: IF l_debug = 1 THEN

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

1564: BEGIN
1565: SELECT prh.requisition_header_id, prh.segment1, prl.requisition_line_id, prl.line_num
1566: INTO l_material_rec.document_id, l_material_rec.document_number
1567: , l_material_rec.document_line_id, l_material_rec.document_line_num
1568: FROM po_requisition_headers_all prh, po_requisition_lines_all prl, rcv_shipment_lines rsl
1569: WHERE rsl.shipment_line_id = l_material_rec.reference_id
1570: AND prh.requisition_header_id = prl.requisition_header_id
1571: AND prl.requisition_line_id = rsl.requisition_line_id;
1572: EXCEPTION

Line 1588: FROM po_requisition_lines_all prl, rcv_shipment_lines rsl

1584: IF (l_material_rec.reference_id IS NOT NULL) THEN
1585: BEGIN
1586: SELECT prl.requisition_line_id, prl.line_num
1587: INTO l_material_rec.document_line_id, l_material_rec.document_line_num
1588: FROM po_requisition_lines_all prl, rcv_shipment_lines rsl
1589: WHERE rsl.shipment_line_id = l_material_rec.reference_id
1590: AND prl.requisition_line_id = rsl.requisition_line_id;
1591: EXCEPTION
1592: WHEN no_data_found THEN