DBA Data[Home] [Help]

APPS.AHL_OSP_ORDERS_PVT dependencies on PO_LINES_ALL

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

2709: p_po_line_id IN NUMBER,
2710: p_osp_order_id IN NUMBER
2711: )IS
2712: CURSOR val_po_line_id_csr(p_po_line_id IN NUMBER, p_osp_order_id IN NUMBER) IS
2713: SELECT 'x' FROM po_lines_all POL, ahl_osp_orders_b OO
2714: WHERE POL.po_line_id = p_po_line_id
2715: AND OO.osp_order_id = p_osp_order_id
2716: AND POL.PO_HEADER_ID = OO.po_header_id
2717: -- Added by jaramana on January 9, 2008 to fix the Bug 5358438/5967633

Line 5458: FROM po_lines_all pol,

5454: (select min(need_by_date)
5455: from po_line_locations_all
5456: where po_line_id = pol.po_line_id
5457: and po_header_id = pol.po_header_id) need_by_date
5458: FROM po_lines_all pol,
5459: mtl_units_of_measure_vl uom
5460: WHERE pol.po_line_id = c_po_line_id
5461: AND uom.unit_of_measure = pol.unit_meas_lookup_code;
5462: -- jaramana January 10, 2008 Ends

Line 5651: from PO_LINES_All corresponding to the PO_LINE_ID passed

5647:
5648: -- Added by jaramana on January 10, 2008 for the Bug 5358438/5967633/5417460
5649: /*
5650: 1. Retrieve the ITEM_ID, ITEM_DESCRIPTION, UNIT_MEAS_LOOKUP_CODE, QUANTITY, LINE_TYPE_ID
5651: from PO_LINES_All corresponding to the PO_LINE_ID passed
5652: 2. ITEM_ID and ITEM_DESCRIPTION cannot both be null
5653: 3. If ITEM_ID is not null, validate it agains the work order's service_item_id
5654: 6. UNIT_MEAS_LOOKUP_CODE, QUANTITY, LINE_TYPE_ID, NEED_BY_DATE are mandatory
5655: */

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

5742: IF(p_x_osp_order_line_rec.po_line_id is NOT NULL) THEN
5743: /*
5744: Note that the messages below will not have PO line numbers associated. They will not ideally occur from
5745: front end as the front LOV already will filter records according to the conditions below
5746: and moreover the data from po_lines_all should not have the below errors unless manually changed in the tables
5747: */
5748: val_svc_item_vs_wo_svc_item (p_x_osp_order_line_rec.workorder_id, l_po_line_attrs.item_id);
5749: 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);
5750: IF(l_po_line_attrs.quantity <=0) THEN

Line 6955: --po_lines_all pl,

6951: ahl_visits_b vst,
6952: ahl_visit_tasks_b vts,
6953: csi_item_instances csiwo,
6954: csi_item_instances csiex,
6955: --po_lines_all pl,
6956: mtl_units_of_measure_tl mtluom
6957: WHERE ospl.osp_order_line_id = p_x_osp_order_line_rec.osp_order_line_id
6958: AND ospl.object_version_number= p_x_osp_order_line_rec.object_version_number
6959: AND ospl.workorder_id = wo.workorder_id(+)