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.POR_RCV_ORD_SV dependencies on STANDARD

Line 1034: POLL.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED') AND

1030: WHERE
1031: NVL(POLL.APPROVED_FLAG,'N') = 'Y' AND
1032: NVL(POLL.CANCEL_FLAG, 'N') = 'N' AND
1033: NVL(POLL.CLOSED_CODE,'OPEN') NOT IN ('FINALLY CLOSED', 'CLOSED', 'CLOSED FOR RECEIVING', 'CANCELLED') AND
1034: POLL.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED') AND
1035: POLL.RECEIVING_ROUTING_ID = 3 AND
1036: POH.PO_HEADER_ID = POLL.PO_HEADER_ID AND
1037: POL.PO_LINE_ID = POLL.PO_LINE_ID AND
1038: POD.PO_HEADER_ID = POLL.PO_HEADER_ID AND

Line 1127: l_order_type_code, -- always PO for both standard and asn

1123: X_user_id,
1124: X_user_id,
1125: SYSDATE,
1126: X_user_id,
1127: l_order_type_code, -- always PO for both standard and asn
1128: l_DESTINATION_TYPE_CODE,
1129: l_DESTINATION_TYPE_CODE,
1130: 'VENDOR', -- same for ASN and PO
1131: X_receipt_date,