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 1039: POLL.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED') AND

1035: WHERE
1036: NVL(POLL.APPROVED_FLAG,'N') = 'Y' AND
1037: NVL(POLL.CANCEL_FLAG, 'N') = 'N' AND
1038: NVL(POLL.CLOSED_CODE,'OPEN') NOT IN ('FINALLY CLOSED', 'CLOSED', 'CLOSED FOR RECEIVING', 'CANCELLED') AND
1039: POLL.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED') AND
1040: POLL.RECEIVING_ROUTING_ID = 3 AND
1041: POH.PO_HEADER_ID = POLL.PO_HEADER_ID AND
1042: POL.PO_LINE_ID = POLL.PO_LINE_ID AND
1043: POD.PO_HEADER_ID = POLL.PO_HEADER_ID AND

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

1129: X_user_id,
1130: X_user_id,
1131: SYSDATE,
1132: X_user_id,
1133: l_order_type_code, -- always PO for both standard and asn
1134: l_DESTINATION_TYPE_CODE,
1135: l_DESTINATION_TYPE_CODE,
1136: 'VENDOR', -- same for ASN and PO
1137: X_receipt_date,