DBA Data[Home] [Help]

APPS.CSD_MASS_RCV_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 1114: FROM oe_order_headers_all ooh, oe_order_types_v oot

1110:
1111: CURSOR cur_order_category (p_header_id NUMBER)
1112: IS
1113: SELECT oot.order_category_code
1114: FROM oe_order_headers_all ooh, oe_order_types_v oot
1115: WHERE ooh.order_type_id = oot.order_type_id
1116: AND ooh.header_id = p_header_id;
1117:
1118: CURSOR cur_po_number_rma (

Line 1124: FROM oe_order_headers_all

1120: p_po_number VARCHAR2
1121: )
1122: IS
1123: SELECT cust_po_number
1124: FROM oe_order_headers_all
1125: WHERE header_id = p_orig_src_header_id
1126: AND cust_po_number = p_po_number;
1127:
1128: CURSOR cur_po_number (

Line 2685: FROM oe_order_headers_all

2681: --Cursors
2682: CURSOR cur_ord_hdr (p_header_id NUMBER)
2683: IS
2684: SELECT booked_flag
2685: FROM oe_order_headers_all
2686: WHERE header_id = p_header_id;
2687:
2688: --
2689: CURSOR cur_ord_details (p_est_detial_id NUMBER)