DBA Data[Home] [Help]

APPS.JAI_PO_RLA_TRIGGER_PKG dependencies on PO_LINES_ALL

Line 106: FROM Po_Lines_All

102: CURSOR cur_bpa_unit_measure(p_blanket_hdr IN NUMBER, p_blanket_line NUMBER) IS
103: SELECT unit_meas_lookup_code
104: FROM Po_Line_Locations_All
105: WHERE Po_Line_Id IN (SELECT Po_Line_Id
106: FROM Po_Lines_All
107: WHERE Po_Header_Id = p_blanket_hdr
108: AND Line_Num = p_blanket_line);
109: lv_unit_meas_lookup po_line_locations_all.unit_meas_lookup_code%TYPE;
110:

Line 1021: v_line_uom PO_LINES_ALL.unit_meas_lookup_code%TYPE;

1017: v_ship_to_organization_id NUMBER;
1018: v_ship_to_location_id NUMBER;
1019: v_price_override PO_LINE_LOCATIONS_ALL.price_override%TYPE;
1020: v_unit_meas_lookup_code PO_LINE_LOCATIONS_ALL.unit_meas_lookup_code%TYPE;
1021: v_line_uom PO_LINES_ALL.unit_meas_lookup_code%TYPE;
1022: v_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;
1023: v_quot_class_code PO_HEADERS_ALL.quotation_class_code%TYPE;
1024: -- End, Vijay Shankar for Bug# 3193592
1025:

Line 1028: FROM Po_Lines_All

1024: -- End, Vijay Shankar for Bug# 3193592
1025:
1026: CURSOR Fetch_Unit_Measure_Cur IS
1027: SELECT Unit_Meas_Lookup_Code
1028: FROM Po_Lines_All
1029: WHERE Po_Line_Id = v_po_line_id;
1030:
1031: CURSOR Fetch_UomCode_Cur(p_uom IN VARCHAR2) IS
1032: SELECT Uom_Code