APPS.JAI_PO_HA_TRIGGER_PKG dependencies on PO_LINES_ALL

Line 17: from po_lines_all pol

13: */
14: PROCEDURE ARU_T1 ( pr_old t_rec%type , pr_new t_rec%type , pv_action varchar2 , pv_return_code out nocopy varchar2 , pv_return_message out nocopy varchar2 ) IS
15: CURSOR c_check_osp_po_distrib is
16: select 1
17: from po_lines_all pol
18: where po_header_id = pr_new.po_header_id
19: and exists
20: (select 1
21: from po_line_types_b

Line 357: FROM Po_Lines_All

353: WHERE Po_Header_Id = v_po_hdr_id;
354:
355: CURSOR Fetch_Item_Cur( Lineid IN NUMBER ) IS
356: SELECT Item_Id
357: FROM Po_Lines_All
358: WHERE Po_Line_Id = Lineid;
359:
360: CURSOR Line_Loc_Cur( lineid IN NUMBER ) IS
361: SELECT Line_Location_Id

Line 367: FROM Po_Lines_All

363: WHERE Po_Line_Id = lineid;
364:
365: CURSOR Fetch_Dtls_Cur( lineid IN NUMBER ) IS
366: SELECT Quantity, Unit_Price, Unit_Meas_Lookup_Code
367: FROM Po_Lines_All
368: WHERE Po_Line_Id = lineid;
369:
370: CURSOR Fetch_Dtls1_Cur( lineid IN NUMBER, linelocid IN NUMBER ) IS
371: SELECT Quantity, Price_Override, Unit_Meas_Lookup_Code