APPS.GMF_INTERNAL_ORDERS dependencies on PO_REQUISITION_LINES_ALL

Line 33: po_requisition_lines_all prl,

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
37: and prh.segment1 = oel.orig_sys_document_ref

Line 115: po_requisition_lines_all prl,

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
119: and prh.segment1 = oel.orig_sys_document_ref