APPS.GMF_INTERNAL_ORDERS dependencies on PO_REQUISITION_HEADERS_ALL

Line 32: FROM po_requisition_headers_all prh,

28: CURSOR Cur_Get_flags (c_req_line_id NUMBER,
29: c_entry_type VARCHAR2) IS
30: SELECT DECODE(min(nvl(t.intorder_posted_ind,-1)),-1,DECODE(c_entry_type,'M','X','O'),'N'),
31: DECODE(NVL(min(t.invoiced_flag),'-1'),'-1',0,'P',2,1)
32: FROM po_requisition_headers_all prh,
33: po_requisition_lines_all prl,
34: oe_order_lines_all oel,
35: ic_tran_pnd t
36: WHERE prl.requisition_header_id = prh.requisition_header_id

Line 114: FROM po_requisition_headers_all prh,

110:
111: CURSOR Cur_get_trans(cp_inv_item_id NUMBER,
112: cp_trans_id NUMBER) IS
113: SELECT max(t.trans_id)
114: FROM po_requisition_headers_all prh,
115: po_requisition_lines_all prl,
116: oe_order_lines_all oel,
117: ic_tran_pnd t
118: WHERE prl.requisition_header_id = prh.requisition_header_id