APPS.JAI_PO_RLA_TRIGGER_PKG dependencies on PO_LINE_LOCATIONS_ALL

Line 104: FROM Po_Line_Locations_All

100: SELECT Line_Location_Id, Quantity, Price_Override*/
101: /*4281841 start*/
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);

Line 109: lv_unit_meas_lookup po_line_locations_all.unit_meas_lookup_code%TYPE;

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:
111: /*4281841 end*/ --pramasub FP end
112:
113: -- Date 01/11/2006 Bug 5228046 added by SACSETHI ( added column from Precedence 6 to 10 )

Line 1006: FROM Po_Line_Locations_All

1002: SELECT Po_Header_Id, Po_Line_Id, ( Price_Override * Quantity ) Total,
1003: Shipment_Type, Po_Release_Id, Source_Shipment_Id
1004: , quantity -- cbabu for Bug# 3051278
1005: , ship_to_organization_id, ship_to_location_id, price_override, Unit_Meas_Lookup_Code -- Vijay Shankar for Bug# 3193592
1006: FROM Po_Line_Locations_All
1007: WHERE Line_Location_Id = v_line_loc_id;
1008:
1009: -- Start, Vijay Shankar for Bug# 3193592
1010: CURSOR c_inventory_org_id(p_ship_to_location_id IN NUMBER) IS

Line 1019: v_price_override PO_LINE_LOCATIONS_ALL.price_override%TYPE;

1015: v_inventory_org_id HR_LOCATIONS.Inventory_Organization_Id%TYPE;
1016: v_line_loc_cnt NUMBER;
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;

Line 1020: v_unit_meas_lookup_code PO_LINE_LOCATIONS_ALL.unit_meas_lookup_code%TYPE;

1016: v_line_loc_cnt NUMBER;
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