DBA Data[Home] [Help]

APPS.OKS_OMINT_PUB dependencies on CSI_ITEM_INSTANCES

Line 1425: From csi_item_instances csi

1421: Select csi.instance_id
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;

Line 1433: From csi_item_instances csi

1429: And ol.line_id = p_line_id;
1430:
1431: Cursor l_product_csr(p_cp_id Number) Is
1432: Select csi.install_date
1433: From csi_item_instances csi
1434: Where csi.instance_id = p_cp_id;
1435:
1436:
1437: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;