DBA Data[Home] [Help]

APPS.JAI_PO_CMN_PKG dependencies on PO_LINES_ALL

Line 44: v_line_num po_lines_all.line_num % type;

40: )
41: IS
42:
43: v_operating_unit org_organization_definitions.operating_unit % type;
44: v_line_num po_lines_all.line_num % type;
45: v_item_id rcv_shipment_lines.item_id % type;
46: v_vendor_name po_vendors.vendor_name % type;
47: v_receipt_num rcv_shipment_headers.receipt_num % type;
48: v_po_num po_headers_all.segment1 % type;

Line 74: FROM po_lines_all

70: v_rcv_rec rcv_cur % ROWTYPE;
71:
72: CURSOR line_cur IS
73: SELECT line_num
74: FROM po_lines_all
75: WHERE po_line_id = v_rcv_rec.po_line_id;
76:
77: CURSOR ven_cur IS
78: SELECT vendor_name

Line 501: v_cum_flag Po_Lines_All.Price_Break_Lookup_Code % TYPE;

497: -- there are multiple price break lines for the specified p_line_id or p_line_num of p_header_id
498:
499: i NUMBER := 1;
500: v_po_line_id NUMBER;
501: v_cum_flag Po_Lines_All.Price_Break_Lookup_Code % TYPE;
502: v_quantity NUMBER; -- := p_line_quantity; --Ramananda for File.Sql.35
503: v_qty NUMBER;
504: v_count NUMBER;
505:

Line 522: FROM Po_Lines_All

518: ORDER BY Quantity;
519:
520: CURSOR Fetch_Line_Id_Cur IS
521: SELECT Po_Line_Id, NVL( Price_Break_Lookup_Code, 'NC' ) Price_Break_Lookup_Code
522: FROM Po_Lines_All
523: WHERE Po_Header_Id = p_header_id
524: AND Line_Num = p_line_num;
525:
526: CURSOR Fetch_Line1_Id_Cur IS

Line 528: FROM Po_Lines_All

524: AND Line_Num = p_line_num;
525:
526: CURSOR Fetch_Line1_Id_Cur IS
527: SELECT NVL( Price_Break_Lookup_Code, 'NC' ) Price_Break_Lookup_Code
528: FROM Po_Lines_All
529: WHERE Po_Line_Id = p_line_id;
530:
531: CURSOR Fetch_Cum_Qty_Cur IS
532: SELECT SUM( Quantity )

Line 677: FROM Po_Lines_All

673:
674: /* Fetch Cumulative pricing flag */
675:
676: CURSOR Fetch_Cum_Pr_Cur IS SELECT Price_Break_Lookup_Code
677: FROM Po_Lines_All
678: WHERE Po_Line_Id = v_po_line_id;
679:
680:
681: ------------------------------>