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_SUPPLY

Line 295: l_from_str := ' FROM rcv_supply rs,';

291: l_select_str := l_select_str || ' rs.quantity, ';
292: l_select_str := l_select_str || ' rs.secondary_quantity,';
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:

Line 938: l_where_str := l_where_str||' FROM rcv_supply rs';

934: l_doc_line_used := 1;
935: l_doc_num_used := 1;
936: l_where_str := l_where_str||' AND mol.inventory_item_id';
937: l_where_str := l_where_str||' IN (SELECT rs.item_id';
938: l_where_str := l_where_str||' FROM rcv_supply rs';
939: l_where_str := l_where_str||' WHERE rs.po_line_id = :doc_line_id';
940: l_where_str := l_where_str||' AND rs.po_header_id = :doc_num_id';
941: l_where_str := l_where_str||' AND rs.to_organization_id = :org_id)';
942: ELSIF p_document_id IS NOT NULL THEN

Line 946: l_where_str := l_where_str||' FROM rcv_supply rs';

942: ELSIF p_document_id IS NOT NULL THEN
943: l_doc_num_used := 1;
944: l_where_str := l_where_str||' AND mol.inventory_item_id';
945: l_where_str := l_where_str||' IN (SELECT rs.item_id';
946: l_where_str := l_where_str||' FROM rcv_supply rs';
947: l_where_str := l_where_str||' WHERE rs.po_header_id = :doc_num_id';
948: l_where_str := l_where_str||' AND rs.to_organization_id = :org_id)';
949: ELSE
950: l_where_str := l_where_str||' AND mol.inventory_item_id';

Line 952: l_where_str := l_where_str||' FROM rcv_supply rs';

948: l_where_str := l_where_str||' AND rs.to_organization_id = :org_id)';
949: ELSE
950: l_where_str := l_where_str||' AND mol.inventory_item_id';
951: l_where_str := l_where_str||' IN (SELECT rs.item_id';
952: l_where_str := l_where_str||' FROM rcv_supply rs';
953: l_where_str := l_where_str||' WHERE rs.to_organization_id = :org_id';
954: l_where_str := l_where_str||' AND rs.po_line_id IS NOT NULL)';
955: END IF;
956: ELSIF (p_document_type = 'REQ') THEN

Line 962: l_where_str := l_where_str||' FROM rcv_supply rs';

958: l_doc_line_used := 1;
959: l_doc_num_used := 1;
960: l_where_str := l_where_str||' AND mol.inventory_item_id';
961: l_where_str := l_where_str||' IN (SELECT rs.item_id';
962: l_where_str := l_where_str||' FROM rcv_supply rs';
963: l_where_str := l_where_str||' WHERE rs.req_line_id = :doc_line_id';
964: l_where_str := l_where_str||' AND rs.req_header_id = :doc_num_id';
965: l_where_str := l_where_str||' AND rs.to_organization_id = :org_id)';
966: ELSIF p_document_id IS NOT NULL THEN

Line 970: l_where_str := l_where_str||' FROM rcv_supply rs';

966: ELSIF p_document_id IS NOT NULL THEN
967: l_doc_num_used := 1;
968: l_where_str := l_where_str||' AND mol.inventory_item_id';
969: l_where_str := l_where_str||' IN (SELECT rs.item_id';
970: l_where_str := l_where_str||' FROM rcv_supply rs';
971: l_where_str := l_where_str||' WHERE rs.req_header_id = :doc_num_id';
972: l_where_str := l_where_str||' AND rs.to_organization_id = :org_id)';
973: ELSE
974: l_where_str := l_where_str||' AND mol.inventory_item_id';

Line 976: l_where_str := l_where_str||' FROM rcv_supply rs';

972: l_where_str := l_where_str||' AND rs.to_organization_id = :org_id)';
973: ELSE
974: l_where_str := l_where_str||' AND mol.inventory_item_id';
975: l_where_str := l_where_str||' IN (SELECT rs.item_id';
976: l_where_str := l_where_str||' FROM rcv_supply rs';
977: l_where_str := l_where_str||' WHERE rs.req_line_id IS NOT NULL';
978: l_where_str := l_where_str||' AND rs.to_organization_id = :org_id)';
979: END IF;
980: ELSIF (p_document_type IN ('ASN','INTSHIP')) THEN

Line 986: l_where_str := l_where_str||' FROM rcv_supply rs';

982: l_doc_line_used := 1;
983: l_doc_num_used := 1;
984: l_where_str := l_where_str||' AND mol.inventory_item_id';
985: l_where_str := l_where_str||' IN (SELECT rs.item_id';
986: l_where_str := l_where_str||' FROM rcv_supply rs';
987: l_where_str := l_where_str||' WHERE rs.shipment_line_id = :doc_line_id';
988: l_where_str := l_where_str||' WHERE rs.shipment_header_id = :doc_num_id';
989: l_where_str := l_where_str||' AND rs.to_organization_id = :org_id)';
990: ELSIF p_document_id IS NOT NULL THEN

Line 994: l_where_str := l_where_str||' FROM rcv_supply rs';

990: ELSIF p_document_id IS NOT NULL THEN
991: l_doc_num_used := 1;
992: l_where_str := l_where_str||' AND mol.inventory_item_id';
993: l_where_str := l_where_str||' IN (SELECT rs.item_id';
994: l_where_str := l_where_str||' FROM rcv_supply rs';
995: l_where_str := l_where_str||' WHERE rs.shipment_header_id = :doc_num_id';
996: l_where_str := l_where_str||' AND rs.to_organization_id = :org_id)';
997: ELSE
998: IF (p_document_type = 'ASN') THEN

Line 1001: l_where_str := l_where_str||' FROM rcv_supply rs,rcv_shipment_headers rsh';

997: ELSE
998: IF (p_document_type = 'ASN') THEN
999: l_where_str := l_where_str||' AND mol.inventory_item_id';
1000: l_where_str := l_where_str||' IN (SELECT rs.item_id';
1001: l_where_str := l_where_str||' FROM rcv_supply rs,rcv_shipment_headers rsh';
1002: l_where_str := l_where_str||' WHERE rsh.asn_type IN (''ASN'',''ASBN'')';
1003: l_where_str := l_where_str||' AND rsh.shipment_num is not null';
1004: l_where_str := l_where_str||' AND rs.shipment_header_id = rsh.shipment_header_id';
1005: l_where_str := l_where_str||' AND rs.to_organization_id = :org_id)';

Line 1009: l_where_str := l_where_str||' FROM rcv_supply rs,rcv_shipment_headers rsh';

1005: l_where_str := l_where_str||' AND rs.to_organization_id = :org_id)';
1006: ELSE
1007: l_where_str := l_where_str||' AND mol.inventory_item_id';
1008: l_where_str := l_where_str||' IN (SELECT rs.item_id';
1009: l_where_str := l_where_str||' FROM rcv_supply rs,rcv_shipment_headers rsh';
1010: l_where_str := l_where_str||' WHERE rsh.asn_type NOT IN (''ASN'',''ASBN'')';
1011: l_where_str := l_where_str||' AND rsh.shipment_num is not null';
1012: l_where_str := l_where_str||' AND rs.to_organization_id = :org_id';
1013: l_where_str := l_where_str||' AND rs.shipment_header_id = rsh.shipment_header_id';

Line 1023: l_where_str := l_where_str||' FROM rcv_supply rs';

1019: l_doc_line_used := 1;
1020: l_doc_num_used := 1;
1021: l_where_str := l_where_str||' AND mol.inventory_item_id';
1022: l_where_str := l_where_str||' IN (SELECT rs.item_id';
1023: l_where_str := l_where_str||' FROM rcv_supply rs';
1024: l_where_str := l_where_str||' WHERE rs.oe_order_line_id = :doc_line_id';
1025: l_where_str := l_where_str||' AND rs.oe_order_header_id = :doc_num_id';
1026: l_where_str := l_where_str||' AND rs.to_organization_id = :org_id)';
1027: ELSIF p_document_line_id IS NOT NULL THEN

Line 1031: l_where_str := l_where_str||' FROM rcv_supply rs';

1027: ELSIF p_document_line_id IS NOT NULL THEN
1028: l_doc_num_used := 1;
1029: l_where_str := l_where_str||' AND mol.inventory_item_id';
1030: l_where_str := l_where_str||' IN (SELECT rs.item_id';
1031: l_where_str := l_where_str||' FROM rcv_supply rs';
1032: l_where_str := l_where_str||' WHERE rs.oe_order_header_id = :doc_num_id';
1033: l_where_str := l_where_str||' AND rs.to_organization_id = :org_id)';
1034: ELSE
1035: l_where_str := l_where_str||' AND mol.inventory_item_id';

Line 1037: l_where_str := l_where_str||' FROM rcv_supply rs';

1033: l_where_str := l_where_str||' AND rs.to_organization_id = :org_id)';
1034: ELSE
1035: l_where_str := l_where_str||' AND mol.inventory_item_id';
1036: l_where_str := l_where_str||' IN (SELECT rs.item_id';
1037: l_where_str := l_where_str||' FROM rcv_supply rs';
1038: l_where_str := l_where_str||' WHERE rs.oe_order_line_id IS NOT NULL';
1039: l_where_str := l_where_str||' AND rs.to_organization_id = :org_id)';
1040: END IF;
1041: END IF;

Line 3179: AND EXISTS (SELECT 1 FROM rcv_serials_supply rss, rcv_supply rs

3175: wpmg.task_id IS NULL and p_task_id IS NULL) OR
3176: (wpmg.project_id = p_project_id AND wpmg.task_id = p_task_id))
3177: AND ((mol.wms_process_flag = 2 and wpmg.selected_flag='Y') OR
3178: (mol.wms_process_flag <> 2))
3179: AND EXISTS (SELECT 1 FROM rcv_serials_supply rss, rcv_supply rs
3180: WHERE rss.serial_num = p_fm_serial_number AND (rss.supply_type_code = 'SHIPMENT' OR (rss.supply_type_code = 'RECEIVING' AND rss.transaction_id = rs.rcv_transaction_id))
3181: AND rss.shipment_line_id = rs.shipment_line_id
3182: AND ((mol.lpn_id IS NULL AND rs.lpn_id IS NULL) OR rs.lpn_id = mol.lpn_id)
3183: AND ((rs.shipment_line_id = mol.reference_id AND mol.reference='SHIPMENT_LINE_ID')

Line 3222: AND NOT EXISTS (SELECT 1 FROM rcv_serials_supply rss, rcv_supply rs

3218: (wpmg.project_id = p_project_id AND wpmg.task_id = p_task_id))
3219: AND ((mol.wms_process_flag = 2 and wpmg.selected_flag='Y') OR
3220: (mol.wms_process_flag <> 2))
3221:
3222: AND NOT EXISTS (SELECT 1 FROM rcv_serials_supply rss, rcv_supply rs
3223: WHERE rss.serial_num = p_fm_serial_number AND rss.shipment_line_id = rs.shipment_line_id
3224: AND rs.item_id=wpmg.inventory_item_id AND rs.to_organization_id=wpmg.organization_id)
3225:
3226: AND NOT EXISTS (SELECT 1 FROM rcv_serials_supply rss, rcv_supply rs

Line 3226: AND NOT EXISTS (SELECT 1 FROM rcv_serials_supply rss, rcv_supply rs

3222: AND NOT EXISTS (SELECT 1 FROM rcv_serials_supply rss, rcv_supply rs
3223: WHERE rss.serial_num = p_fm_serial_number AND rss.shipment_line_id = rs.shipment_line_id
3224: AND rs.item_id=wpmg.inventory_item_id AND rs.to_organization_id=wpmg.organization_id)
3225:
3226: AND NOT EXISTS (SELECT 1 FROM rcv_serials_supply rss, rcv_supply rs
3227: WHERE (rss.supply_type_code = 'SHIPMENT' OR (rss.supply_type_code = 'RECEIVING' AND rss.transaction_id = rs.rcv_transaction_id))
3228: AND rss.shipment_line_id = rs.shipment_line_id
3229: AND ((mol.lpn_id IS NULL AND rs.lpn_id IS NULL) OR rs.lpn_id = mol.lpn_id)
3230: AND ((rs.shipment_line_id = mol.reference_id AND mol.reference='SHIPMENT_LINE_ID')