APPS.JAI_PO_RLA_TRIGGER_PKG dependencies on PO_LINE_LOCATIONS_ALL

Line 98: FROM Po_Line_Locations_All

94: SELECT Line_Location_Id, Quantity, Price_Override*/
95: /*4281841 start*/
96: CURSOR cur_bpa_unit_measure(p_blanket_hdr IN NUMBER, p_blanket_line NUMBER) IS
97: SELECT unit_meas_lookup_code
98: FROM Po_Line_Locations_All
99: WHERE Po_Line_Id IN (SELECT Po_Line_Id
100: FROM Po_Lines_All
101: WHERE Po_Header_Id = p_blanket_hdr
102: AND Line_Num = p_blanket_line);

Line 103: lv_unit_meas_lookup po_line_locations_all.unit_meas_lookup_code%TYPE;

99: WHERE Po_Line_Id IN (SELECT Po_Line_Id
100: FROM Po_Lines_All
101: WHERE Po_Header_Id = p_blanket_hdr
102: AND Line_Num = p_blanket_line);
103: lv_unit_meas_lookup po_line_locations_all.unit_meas_lookup_code%TYPE;
104:
105: /*4281841 end*/ --pramasub FP end
106:
107: -- Date 01/11/2006 Bug 5228046 added by SACSETHI ( added column from Precedence 6 to 10 )

Line 919: FROM Po_Line_Locations_All

915: SELECT Po_Header_Id, Po_Line_Id, ( Price_Override * Quantity ) Total,
916: Shipment_Type, Po_Release_Id, Source_Shipment_Id
917: , quantity -- cbabu for Bug# 3051278
918: , ship_to_organization_id, ship_to_location_id, price_override, Unit_Meas_Lookup_Code -- Vijay Shankar for Bug# 3193592
919: FROM Po_Line_Locations_All
920: WHERE Line_Location_Id = v_line_loc_id;
921:
922: -- Start, Vijay Shankar for Bug# 3193592
923: CURSOR c_inventory_org_id(p_ship_to_location_id IN NUMBER) IS

Line 932: v_price_override PO_LINE_LOCATIONS_ALL.price_override%TYPE;

928: v_inventory_org_id HR_LOCATIONS.Inventory_Organization_Id%TYPE;
929: v_line_loc_cnt NUMBER;
930: v_ship_to_organization_id NUMBER;
931: v_ship_to_location_id NUMBER;
932: v_price_override PO_LINE_LOCATIONS_ALL.price_override%TYPE;
933: v_unit_meas_lookup_code PO_LINE_LOCATIONS_ALL.unit_meas_lookup_code%TYPE;
934: v_line_uom PO_LINES_ALL.unit_meas_lookup_code%TYPE;
935: v_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;
936: v_quot_class_code PO_HEADERS_ALL.quotation_class_code%TYPE;

Line 933: v_unit_meas_lookup_code PO_LINE_LOCATIONS_ALL.unit_meas_lookup_code%TYPE;

929: v_line_loc_cnt NUMBER;
930: v_ship_to_organization_id NUMBER;
931: v_ship_to_location_id NUMBER;
932: v_price_override PO_LINE_LOCATIONS_ALL.price_override%TYPE;
933: v_unit_meas_lookup_code PO_LINE_LOCATIONS_ALL.unit_meas_lookup_code%TYPE;
934: v_line_uom PO_LINES_ALL.unit_meas_lookup_code%TYPE;
935: v_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;
936: v_quot_class_code PO_HEADERS_ALL.quotation_class_code%TYPE;
937: -- End, Vijay Shankar for Bug# 3193592