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.CSD_MASS_RCV_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 1120: FROM oe_order_headers_all ooh, oe_order_types_v oot

1116:
1117: CURSOR cur_order_category (p_header_id NUMBER)
1118: IS
1119: SELECT oot.order_category_code
1120: FROM oe_order_headers_all ooh, oe_order_types_v oot
1121: WHERE ooh.order_type_id = oot.order_type_id
1122: AND ooh.header_id = p_header_id;
1123:
1124: CURSOR cur_po_number_rma (

Line 1130: FROM oe_order_headers_all

1126: p_po_number VARCHAR2
1127: )
1128: IS
1129: SELECT cust_po_number
1130: FROM oe_order_headers_all
1131: WHERE header_id = p_orig_src_header_id
1132: AND cust_po_number = p_po_number;
1133:
1134: CURSOR cur_po_number (

Line 2702: FROM oe_order_headers_all

2698: --Cursors
2699: CURSOR cur_ord_hdr (p_header_id NUMBER)
2700: IS
2701: SELECT booked_flag
2702: FROM oe_order_headers_all
2703: WHERE header_id = p_header_id;
2704:
2705: --
2706: CURSOR cur_ord_details (p_est_detial_id NUMBER)