DBA Data[Home] [Help]

APPS.OKS_OMINT_PUB dependencies on OE_ORDER_LINES_ALL

Line 1410: From oe_order_lines_all

1406: ,service_reference_line_id
1407: ,service_duration
1408: ,service_period
1409: ,fulfillment_date
1410: From oe_order_lines_all
1411: Where line_id = p_order_line_id;
1412:
1413: Cursor l_get_warr_dates_csr(p_cp_id Number) IS
1414: Select max(ol.end_date)

Line 1426: ,oe_order_lines_all ol

1422: ,csi.install_date
1423: ,ol.Actual_shipment_date
1424: ,ol.schedule_ship_date
1425: From csi_item_instances csi
1426: ,oe_order_lines_all ol
1427: Where ol.line_id = csi.last_oe_order_line_id
1428: And ol.inventory_item_id = csi.inventory_item_id
1429: And ol.line_id = p_line_id;
1430:

Line 1803: oe_order_lines_all oel

1799: /* CURSOR om_period_csr(p_id IN NUMBER) IS
1800: select service_period,service_duration
1801: from okc_k_lines_b subline,
1802: okc_k_rel_objs rel,
1803: oe_order_lines_all oel
1804: where subline.cle_id = p_id
1805: and rel.cle_id = subline.id
1806: and oel.line_id = rel.object1_id1;*/
1807: