DBA Data[Home] [Help]

APPS.OKS_OMINT_PUB dependencies on CSI_ITEM_INSTANCES

Line 1430: From csi_item_instances csi

1426: /*Select csi.instance_id
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; */

Line 1440: FROM csi_item_instances csi,

1436: csi.install_date,
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

Line 1451: From csi_item_instances csi

1447: AND ol.line_id = p_line_id;
1448:
1449: Cursor l_product_csr(p_cp_id Number) Is
1450: Select csi.install_date
1451: From csi_item_instances csi
1452: Where csi.instance_id = p_cp_id;
1453:
1454: /* Added cursor for Bug#15885433*/
1455: CURSOR l_organization_csr(p_org_id Number) Is