APPS.OKS_OMINT_PUB dependencies on OE_ORDER_LINES_ALL

Line 1414: From oe_order_lines_all

1410: ,fulfillment_date
1411: ,org_id
1412: ,ship_from_org_id
1413: ,sold_from_org_id
1414: From oe_order_lines_all
1415: Where line_id = p_order_line_id;
1416:
1417: Cursor l_get_warr_dates_csr(p_cp_id Number) IS
1418: Select max(ol.end_date)

Line 1431: ,oe_order_lines_all ol

1427: ,csi.install_date
1428: ,ol.Actual_shipment_date
1429: ,ol.schedule_ship_date
1430: From csi_item_instances csi
1431: ,oe_order_lines_all ol
1432: Where ol.line_id = csi.last_oe_order_line_id
1433: And ol.inventory_item_id = csi.inventory_item_id
1434: And ol.line_id = p_line_id; */
1435: SELECT csi.instance_id,

Line 1441: oe_order_lines_all ol,

1437: ol.actual_shipment_date,
1438: ol.schedule_ship_date,
1439: mtl.service_starting_delay
1440: FROM csi_item_instances csi,
1441: oe_order_lines_all ol,
1442: okx_system_items_v mtl
1443: WHERE csi.inventory_item_id = mtl.id1
1444: AND ol.inventory_item_id = csi.inventory_item_id
1445: AND mtl.id2 = OKC_CONTEXT.GET_OKC_ORGANIZATION_ID

Line 1850: oe_order_lines_all oel

1846: /* CURSOR om_period_csr(p_id IN NUMBER) IS
1847: select service_period,service_duration
1848: from okc_k_lines_b subline,
1849: okc_k_rel_objs rel,
1850: oe_order_lines_all oel
1851: where subline.cle_id = p_id
1852: and rel.cle_id = subline.id
1853: and oel.line_id = rel.object1_id1;*/
1854: