DBA Data[Home] [Help]

APPS.AHL_OSP_ORDERS_PVT dependencies on PO_LINES_ALL

Line 2692: SELECT 'x' FROM po_lines_all POL, ahl_osp_orders_b OO

2688: p_po_line_id IN NUMBER,
2689: p_osp_order_id IN NUMBER
2690: )IS
2691: CURSOR val_po_line_id_csr(p_po_line_id IN NUMBER, p_osp_order_id IN NUMBER) IS
2692: SELECT 'x' FROM po_lines_all POL, ahl_osp_orders_b OO
2693: WHERE POL.po_line_id = p_po_line_id
2694: AND OO.osp_order_id = p_osp_order_id
2695: AND POL.PO_HEADER_ID = OO.po_header_id
2696: -- Added by jaramana on January 9, 2008 to fix the Bug 5358438/5967633

Line 5108: FROM po_lines_all pol,

5104: (select min(need_by_date)
5105: from po_line_locations_all
5106: where po_line_id = pol.po_line_id
5107: and po_header_id = pol.po_header_id) need_by_date
5108: FROM po_lines_all pol,
5109: mtl_units_of_measure_vl uom
5110: WHERE pol.po_line_id = c_po_line_id
5111: AND uom.unit_of_measure = pol.unit_meas_lookup_code;
5112: -- jaramana January 10, 2008 Ends

Line 5301: from PO_LINES_All corresponding to the PO_LINE_ID passed

5297:
5298: -- Added by jaramana on January 10, 2008 for the Bug 5358438/5967633/5417460
5299: /*
5300: 1. Retrieve the ITEM_ID, ITEM_DESCRIPTION, UNIT_MEAS_LOOKUP_CODE, QUANTITY, LINE_TYPE_ID
5301: from PO_LINES_All corresponding to the PO_LINE_ID passed
5302: 2. ITEM_ID and ITEM_DESCRIPTION cannot both be null
5303: 3. If ITEM_ID is not null, validate it agains the work order's service_item_id
5304: 6. UNIT_MEAS_LOOKUP_CODE, QUANTITY, LINE_TYPE_ID, NEED_BY_DATE are mandatory
5305: */

Line 5396: and moreover the data from po_lines_all should not have the below errors unless manually changed in the tables

5392: IF(p_x_osp_order_line_rec.po_line_id is NOT NULL) THEN
5393: /*
5394: Note that the messages below will not have PO line numbers associated. They will not ideally occur from
5395: front end as the front LOV already will filter records according to the conditions below
5396: and moreover the data from po_lines_all should not have the below errors unless manually changed in the tables
5397: */
5398: val_svc_item_vs_wo_svc_item (p_x_osp_order_line_rec.workorder_id, l_po_line_attrs.item_id);
5399: validate_service_item_uom(l_po_line_attrs.item_id, p_x_osp_order_line_rec.service_item_uom_code, p_x_osp_order_line_rec.inventory_org_id);
5400: IF(l_po_line_attrs.quantity <=0) THEN

Line 6506: --po_lines_all pl,

6502: ahl_visits_b vst,
6503: ahl_visit_tasks_b vts,
6504: csi_item_instances csiwo,
6505: csi_item_instances csiex,
6506: --po_lines_all pl,
6507: mtl_units_of_measure_tl mtluom
6508: WHERE ospl.osp_order_line_id = p_x_osp_order_line_rec.osp_order_line_id
6509: AND ospl.object_version_number= p_x_osp_order_line_rec.object_version_number
6510: AND ospl.workorder_id = wo.workorder_id(+)