eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSL_CSI_ITEM_INSTANCES_ACC_PKG dependencies on CSI_ITEM_INSTANCES

Line 1: PACKAGE BODY CSL_CSI_ITEM_INSTANCES_ACC_PKG AS

1: PACKAGE BODY CSL_CSI_ITEM_INSTANCES_ACC_PKG AS
2: /* $Header: csliiacb.pls 120.0 2005/05/25 11:05:37 appldev noship $ */
3:
4: /*** Globals ***/
5: g_acc_table_name CONSTANT VARCHAR2(30) := 'CSL_CSI_ITEM_INSTANCES_ACC';

Line 5: g_acc_table_name CONSTANT VARCHAR2(30) := 'CSL_CSI_ITEM_INSTANCES_ACC';

1: PACKAGE BODY CSL_CSI_ITEM_INSTANCES_ACC_PKG AS
2: /* $Header: csliiacb.pls 120.0 2005/05/25 11:05:37 appldev noship $ */
3:
4: /*** Globals ***/
5: g_acc_table_name CONSTANT VARCHAR2(30) := 'CSL_CSI_ITEM_INSTANCES_ACC';
6: g_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
7: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_CSI_ITEM_INSTANCES');
8: g_table_name CONSTANT VARCHAR2(30) := 'CSI_ITEM_INSTANCES';
9: g_pk1_name CONSTANT VARCHAR2(30) := 'INSTANCE_ID';

Line 7: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_CSI_ITEM_INSTANCES');

3:
4: /*** Globals ***/
5: g_acc_table_name CONSTANT VARCHAR2(30) := 'CSL_CSI_ITEM_INSTANCES_ACC';
6: g_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
7: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_CSI_ITEM_INSTANCES');
8: g_table_name CONSTANT VARCHAR2(30) := 'CSI_ITEM_INSTANCES';
9: g_pk1_name CONSTANT VARCHAR2(30) := 'INSTANCE_ID';
10: g_debug_level NUMBER; -- debug level
11: g_resource_id_list dbms_sql.Number_Table; -- list of resource to which an item instance should be replicated

Line 8: g_table_name CONSTANT VARCHAR2(30) := 'CSI_ITEM_INSTANCES';

4: /*** Globals ***/
5: g_acc_table_name CONSTANT VARCHAR2(30) := 'CSL_CSI_ITEM_INSTANCES_ACC';
6: g_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
7: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_CSI_ITEM_INSTANCES');
8: g_table_name CONSTANT VARCHAR2(30) := 'CSI_ITEM_INSTANCES';
9: g_pk1_name CONSTANT VARCHAR2(30) := 'INSTANCE_ID';
10: g_debug_level NUMBER; -- debug level
11: g_resource_id_list dbms_sql.Number_Table; -- list of resource to which an item instance should be replicated
12:

Line 27: FROM CSI_ITEM_INSTANCES

23: RETURN BOOLEAN
24: IS
25: CURSOR c_item_instance (b_instance_id NUMBER) IS
26: SELECT null
27: FROM CSI_ITEM_INSTANCES
28: WHERE instance_id = b_instance_id;
29: r_item_instance c_item_instance%ROWTYPE;
30: BEGIN
31: /*** get debug level ***/

Line 98: where package_name = 'CSL_CSI_ITEM_INSTANCES_ACC_PKG'

94: /*** get the last run date of the concurent program ***/
95: CURSOR c_LastRundate IS
96: select LAST_RUN_DATE
97: from JTM_CON_REQUEST_DATA
98: where package_name = 'CSL_CSI_ITEM_INSTANCES_ACC_PKG'
99: AND procedure_name = 'CON_ITEM_ATTR';
100: r_LastRundate c_LastRundate%ROWTYPE;
101:
102: CURSOR c_insert_diffs(b_last_run_date date) IS

Line 104: FROM CSI_IEA_VALUES civ, CSI_I_EXTENDED_ATTRIBS ciea, csl_csi_item_instances_acc acc

100: r_LastRundate c_LastRundate%ROWTYPE;
101:
102: CURSOR c_insert_diffs(b_last_run_date date) IS
103: SELECT ATTRIBUTE_VALUE_ID, RESOURCE_ID
104: FROM CSI_IEA_VALUES civ, CSI_I_EXTENDED_ATTRIBS ciea, csl_csi_item_instances_acc acc
105: WHERE civ.attribute_id = ciea.attribute_id
106: AND civ.instance_id = acc.instance_id
107: AND NVL(ciea.active_start_date, sysdate) <= sysdate
108: AND NVL(ciea.active_end_date, sysdate) >= sysdate

Line 117: csl_csi_item_instances_acc csiacc, CSL_CSI_ITEM_ATTR_ACC acc

113:
114: CURSOR c_updates(b_last_run_date date) IS
115: SELECT acc.ACCESS_ID, acc.RESOURCE_ID
116: FROM CSI_IEA_VALUES civ, CSI_I_EXTENDED_ATTRIBS ciea,
117: csl_csi_item_instances_acc csiacc, CSL_CSI_ITEM_ATTR_ACC acc
118: WHERE civ.attribute_id = ciea.attribute_id
119: AND civ.instance_id = csiacc.instance_id
120: AND civ.ATTRIBUTE_VALUE_ID = acc.ATTRIBUTE_VALUE_ID
121: AND NVL(ciea.active_start_date, sysdate) <= sysdate

Line 129: FROM CSI_IEA_VALUES civ, CSI_I_EXTENDED_ATTRIBS ciea, csl_csi_item_instances_acc acc

125:
126: /*
127: CURSOR c_end_dates(b_last_run_date date) IS
128: SELECT ATTRIBUTE_VALUE_ID, RESOURCE_ID
129: FROM CSI_IEA_VALUES civ, CSI_I_EXTENDED_ATTRIBS ciea, csl_csi_item_instances_acc acc
130: WHERE civ.attribute_id = ciea.attribute_id
131: AND civ.instance_id = acc.instance_id
132: AND NVL(ciea.active_start_date, sysdate) <= sysdate
133: AND NVL(ciea.active_end_date, sysdate) < sysdate

Line 237: WHERE package_name = 'CSL_CSI_ITEM_INSTANCES_ACC_PKG'

233: */
234:
235: /*Update the last run date*/
236: UPDATE jtm_con_request_data SET last_run_date = l_current_run_date
237: WHERE package_name = 'CSL_CSI_ITEM_INSTANCES_ACC_PKG'
238: AND procedure_name = 'CON_ITEM_ATTR';
239:
240: COMMIT;
241:

Line 252: p_message := 'CSL_CSI_ITEM_INSTANCES_ACC_PKG.CON_ITEM_ATTR Executed successfully';

248: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
249: END IF;
250:
251: p_status := 'FINE';
252: p_message := 'CSL_CSI_ITEM_INSTANCES_ACC_PKG.CON_ITEM_ATTR Executed successfully';
253:
254: EXCEPTION
255:
256: WHEN OTHERS THEN

Line 258: p_message := 'Error in CSL_CSI_ITEM_INSTANCES_ACC_PKG.CON_ITEM_ATTR: ' || substr(SQLERRM, 1, 2000);

254: EXCEPTION
255:
256: WHEN OTHERS THEN
257: p_status := 'ERROR';
258: p_message := 'Error in CSL_CSI_ITEM_INSTANCES_ACC_PKG.CON_ITEM_ATTR: ' || substr(SQLERRM, 1, 2000);
259: jtm_message_log_pkg.Log_Msg
260: (0,
261: 'CSL_CSI_ITEM_ATTR_ACC',
262: 'Exception occured in CON_ITEM_ATTR ',

Line 409: FROM CSI_ITEM_INSTANCES

405: , inv_organization_id
406: , LOCATION_ID
407: , location_type_code
408: , INV_MASTER_ORGANIZATION_ID
409: FROM CSI_ITEM_INSTANCES
410: WHERE instance_id = b_instance_id;
411: r_ii c_ii%ROWTYPE;
412: l_org_id NUMBER;
413: l_return BOOLEAN;

Line 556: FROM CSI_ITEM_INSTANCES

552: , inv_organization_id
553: , LOCATION_ID
554: , location_type_code
555: , INV_MASTER_ORGANIZATION_ID
556: FROM CSI_ITEM_INSTANCES
557: WHERE instance_id = b_instance_id;
558: r_ii c_ii%ROWTYPE;
559: l_org_id NUMBER;
560: l_return BOOLEAN;

Line 812: FROM CSL_CSI_ITEM_INSTANCES_ACC acc, CSI_ITEM_INSTANCES cii

808: b_party_id NUMBER,
809: b_instance_id NUMBER,
810: b_parent_instance_id NUMBER ) IS
811: SELECT acc.instance_id
812: FROM CSL_CSI_ITEM_INSTANCES_ACC acc, CSI_ITEM_INSTANCES cii
813: WHERE acc.instance_id = cii.instance_id
814: AND acc.resource_id = b_resource_id
815: AND owner_party_id = b_party_id
816: AND ( ( cii.location_id = b_party_site_id

Line 825: SELECT acc.instance_id FROM CSL_CSI_ITEM_INSTANCES_ACC acc

821: )
822: )
823: AND acc.instance_id NOT IN
824: (
825: SELECT acc.instance_id FROM CSL_CSI_ITEM_INSTANCES_ACC acc
826: WHERE acc.resource_id = b_resource_id AND
827: acc.instance_id IN (b_instance_id, b_parent_instance_id)
828: UNION
829: SELECT acc.instance_id FROM CSL_CSI_ITEM_INSTANCES_ACC acc

Line 829: SELECT acc.instance_id FROM CSL_CSI_ITEM_INSTANCES_ACC acc

825: SELECT acc.instance_id FROM CSL_CSI_ITEM_INSTANCES_ACC acc
826: WHERE acc.resource_id = b_resource_id AND
827: acc.instance_id IN (b_instance_id, b_parent_instance_id)
828: UNION
829: SELECT acc.instance_id FROM CSL_CSI_ITEM_INSTANCES_ACC acc
830: WHERE acc.resource_id = b_resource_id AND
831: acc.instance_id IN
832: (
833: SELECT subject_id FROM CSI_II_RELATIONSHIPS

Line 847: FROM CSI_ITEM_INSTANCES cii, MTL_SYSTEM_ITEMS si

843: b_party_site_id NUMBER,
844: b_location_id NUMBER,
845: b_party_id NUMBER ) IS
846: SELECT cii.instance_id
847: FROM CSI_ITEM_INSTANCES cii, MTL_SYSTEM_ITEMS si
848: WHERE si.organization_id = NVL( cii.inv_organization_id,
849: cii.inv_master_organization_id )
850: AND si.inventory_item_id = cii.inventory_item_id
851: AND cii.instance_id NOT IN

Line 852: ( SELECT acc.instance_id FROM CSL_CSI_ITEM_INSTANCES_ACC acc

848: WHERE si.organization_id = NVL( cii.inv_organization_id,
849: cii.inv_master_organization_id )
850: AND si.inventory_item_id = cii.inventory_item_id
851: AND cii.instance_id NOT IN
852: ( SELECT acc.instance_id FROM CSL_CSI_ITEM_INSTANCES_ACC acc
853: WHERE acc.resource_id = b_resource_id
854: )
855: AND owner_party_id = b_party_id
856: AND ( ( cii.location_id = b_party_site_id

Line 1095: FROM CSL_CSI_ITEM_INSTANCES_ACC acc, CSI_ITEM_INSTANCES cii

1091: b_party_site_id NUMBER,
1092: b_location_id NUMBER,
1093: b_party_id NUMBER ) IS
1094: SELECT acc.instance_id
1095: FROM CSL_CSI_ITEM_INSTANCES_ACC acc, CSI_ITEM_INSTANCES cii
1096: WHERE acc.instance_id = cii.instance_id
1097: AND acc.resource_id = b_resource_id
1098: AND owner_party_id = b_party_id
1099: AND ( ( cii.location_id = b_party_site_id

Line 1163: FROM csi_item_instances

1159: SELECT instance_id,
1160: INV_ORGANIZATION_ID,
1161: INVENTORY_ITEM_ID,
1162: INV_MASTER_ORGANIZATION_ID
1163: FROM csi_item_instances
1164: WHERE inventory_item_id = b_inventory_item_id
1165: AND inv_organization_id = b_organization_id
1166: AND inv_subinventory_name = b_subinventory_code;
1167:

Line 1233: FROM csi_item_instances

1229: SELECT instance_id,
1230: INV_ORGANIZATION_ID,
1231: INVENTORY_ITEM_ID,
1232: INV_MASTER_ORGANIZATION_ID
1233: FROM csi_item_instances
1234: WHERE inventory_item_id = b_inventory_item_id
1235: AND inv_organization_id = b_organization_id
1236: AND inv_subinventory_name = b_subinventory_code;
1237:

Line 1312: FROM CSL_CSI_ITEM_INSTANCES_ACC cia

1308: l_dummy BOOLEAN;
1309:
1310: CURSOR c_is_parent( b_instance_id NUMBER ) IS
1311: SELECT cia.resource_id
1312: FROM CSL_CSI_ITEM_INSTANCES_ACC cia
1313: , CSI_II_RELATIONSHIPS cir
1314: WHERE cir.relationship_type_code = 'COMPONENT-OF'
1315: AND cir.subject_id = cia.instance_id
1316: AND cir.object_id = b_instance_id;

Line 1320: FROM CSL_CSI_ITEM_INSTANCES_ACC cia

1316: AND cir.object_id = b_instance_id;
1317:
1318: CURSOR c_is_child( b_instance_id NUMBER ) IS
1319: SELECT cia.resource_id
1320: FROM CSL_CSI_ITEM_INSTANCES_ACC cia
1321: , CSI_II_RELATIONSHIPS cir
1322: WHERE cir.relationship_type_code = 'COMPONENT-OF'
1323: AND cir.object_id = cia.instance_id
1324: AND cir.subject_id = b_instance_id;

Line 1391: fnd_msg_pub.Add_Exc_Msg('CSL_CSI_ITEM_INSTANCES_ACC_PKG','POST_INSERT_ITEM_INSTANCE',sqlerrm);

1387: , g_table_name
1388: , 'Caught exception in POST_INSERT hook:' || fnd_global.local_chr(10) || sqlerrm
1389: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
1390: END IF;
1391: fnd_msg_pub.Add_Exc_Msg('CSL_CSI_ITEM_INSTANCES_ACC_PKG','POST_INSERT_ITEM_INSTANCE',sqlerrm);
1392: -- x_return_status := FND_API.G_RET_STS_ERROR;
1393: x_return_status := FND_API.G_RET_STS_SUCCESS;
1394: END POST_INSERT_ITEM_INSTANCE;
1395:

Line 1437: FROM csl_csi_item_instances_acc

1433: IS
1434:
1435: CURSOR c_changed(b_last_run_date DATE) IS
1436: SELECT ACCESS_ID , resource_id
1437: FROM csl_csi_item_instances_acc
1438: WHERE (instance_id in
1439: (SELECT instance_id
1440: FROM csi_item_instances
1441: WHERE last_update_date >= b_last_run_date));

Line 1440: FROM csi_item_instances

1436: SELECT ACCESS_ID , resource_id
1437: FROM csl_csi_item_instances_acc
1438: WHERE (instance_id in
1439: (SELECT instance_id
1440: FROM csi_item_instances
1441: WHERE last_update_date >= b_last_run_date));
1442:
1443: l_org_id NUMBER;
1444: l_dummy BOOLEAN;

Line 1446: TYPE access_idTab IS TABLE OF CSL_CSI_ITEM_INSTANCES_ACC.access_id%TYPE INDEX BY BINARY_INTEGER;

1442:
1443: l_org_id NUMBER;
1444: l_dummy BOOLEAN;
1445:
1446: TYPE access_idTab IS TABLE OF CSL_CSI_ITEM_INSTANCES_ACC.access_id%TYPE INDEX BY BINARY_INTEGER;
1447: TYPE inst_idTab IS TABLE OF CSL_CSI_ITEM_INSTANCES_ACC.instance_id%TYPE INDEX BY BINARY_INTEGER;
1448: TYPE resource_idTab IS TABLE OF CSL_CSI_ITEM_INSTANCES_ACC.resource_id%TYPE INDEX BY BINARY_INTEGER;
1449: TYPE inv_org_idTab IS TABLE OF CSI_ITEM_INSTANCES.INV_ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
1450: TYPE inv_itm_idTab IS TABLE OF CSI_ITEM_INSTANCES.INVENTORY_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;

Line 1447: TYPE inst_idTab IS TABLE OF CSL_CSI_ITEM_INSTANCES_ACC.instance_id%TYPE INDEX BY BINARY_INTEGER;

1443: l_org_id NUMBER;
1444: l_dummy BOOLEAN;
1445:
1446: TYPE access_idTab IS TABLE OF CSL_CSI_ITEM_INSTANCES_ACC.access_id%TYPE INDEX BY BINARY_INTEGER;
1447: TYPE inst_idTab IS TABLE OF CSL_CSI_ITEM_INSTANCES_ACC.instance_id%TYPE INDEX BY BINARY_INTEGER;
1448: TYPE resource_idTab IS TABLE OF CSL_CSI_ITEM_INSTANCES_ACC.resource_id%TYPE INDEX BY BINARY_INTEGER;
1449: TYPE inv_org_idTab IS TABLE OF CSI_ITEM_INSTANCES.INV_ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
1450: TYPE inv_itm_idTab IS TABLE OF CSI_ITEM_INSTANCES.INVENTORY_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
1451: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;

Line 1448: TYPE resource_idTab IS TABLE OF CSL_CSI_ITEM_INSTANCES_ACC.resource_id%TYPE INDEX BY BINARY_INTEGER;

1444: l_dummy BOOLEAN;
1445:
1446: TYPE access_idTab IS TABLE OF CSL_CSI_ITEM_INSTANCES_ACC.access_id%TYPE INDEX BY BINARY_INTEGER;
1447: TYPE inst_idTab IS TABLE OF CSL_CSI_ITEM_INSTANCES_ACC.instance_id%TYPE INDEX BY BINARY_INTEGER;
1448: TYPE resource_idTab IS TABLE OF CSL_CSI_ITEM_INSTANCES_ACC.resource_id%TYPE INDEX BY BINARY_INTEGER;
1449: TYPE inv_org_idTab IS TABLE OF CSI_ITEM_INSTANCES.INV_ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
1450: TYPE inv_itm_idTab IS TABLE OF CSI_ITEM_INSTANCES.INVENTORY_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
1451: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
1452: l_tab_resource_id ASG_DOWNLOAD.USER_LIST;

Line 1449: TYPE inv_org_idTab IS TABLE OF CSI_ITEM_INSTANCES.INV_ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;

1445:
1446: TYPE access_idTab IS TABLE OF CSL_CSI_ITEM_INSTANCES_ACC.access_id%TYPE INDEX BY BINARY_INTEGER;
1447: TYPE inst_idTab IS TABLE OF CSL_CSI_ITEM_INSTANCES_ACC.instance_id%TYPE INDEX BY BINARY_INTEGER;
1448: TYPE resource_idTab IS TABLE OF CSL_CSI_ITEM_INSTANCES_ACC.resource_id%TYPE INDEX BY BINARY_INTEGER;
1449: TYPE inv_org_idTab IS TABLE OF CSI_ITEM_INSTANCES.INV_ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
1450: TYPE inv_itm_idTab IS TABLE OF CSI_ITEM_INSTANCES.INVENTORY_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
1451: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
1452: l_tab_resource_id ASG_DOWNLOAD.USER_LIST;
1453:

Line 1450: TYPE inv_itm_idTab IS TABLE OF CSI_ITEM_INSTANCES.INVENTORY_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;

1446: TYPE access_idTab IS TABLE OF CSL_CSI_ITEM_INSTANCES_ACC.access_id%TYPE INDEX BY BINARY_INTEGER;
1447: TYPE inst_idTab IS TABLE OF CSL_CSI_ITEM_INSTANCES_ACC.instance_id%TYPE INDEX BY BINARY_INTEGER;
1448: TYPE resource_idTab IS TABLE OF CSL_CSI_ITEM_INSTANCES_ACC.resource_id%TYPE INDEX BY BINARY_INTEGER;
1449: TYPE inv_org_idTab IS TABLE OF CSI_ITEM_INSTANCES.INV_ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
1450: TYPE inv_itm_idTab IS TABLE OF CSI_ITEM_INSTANCES.INVENTORY_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
1451: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
1452: l_tab_resource_id ASG_DOWNLOAD.USER_LIST;
1453:
1454: acc_id access_idTab;

Line 1503: FROM csi_item_instances cii

1499: , cii.INV_ORGANIZATION_ID
1500: , cii.INVENTORY_ITEM_ID
1501: , cqa.RESOURCE_ID
1502: BULK COLLECT INTO inst_id, inv_org_id, inv_itm_id, res_id
1503: FROM csi_item_instances cii
1504: , csl_mtl_onhand_qty_acc cqa
1505: , csi_instance_statuses iis
1506: WHERE cii.inventory_item_id = cqa.inventory_item_id
1507: AND cii.inv_organization_id = cqa.organization_id

Line 1520: FROM csl_csi_item_instances_acc cia

1516: AND cii.INSTANCE_STATUS_ID = iis.instance_status_id
1517: AND NVL(iis.terminated_flag,'N') = 'N'
1518: AND NOT EXISTS
1519: ( SELECT null
1520: FROM csl_csi_item_instances_acc cia
1521: WHERE cii.instance_id = cia.instance_id
1522: AND cqa.resource_id = cia.resource_id
1523: );
1524:

Line 1563: FROM CSL_CSI_ITEM_INSTANCES_ACC iiac

1559: , ii.INV_ORGANIZATION_ID
1560: , ii.INVENTORY_ITEM_ID
1561: , iiac.RESOURCE_ID
1562: BULK COLLECT INTO inst_id, inv_org_id, inv_itm_id, res_id
1563: FROM CSL_CSI_ITEM_INSTANCES_ACC iiac
1564: , CSI_ITEM_INSTANCES ii
1565: , CSI_INSTANCE_STATUSES iis
1566: WHERE ii.INV_ORGANIZATION_ID IS NOT NULL
1567: AND ii.INV_SUBINVENTORY_NAME IS NOT NULL

Line 1564: , CSI_ITEM_INSTANCES ii

1560: , ii.INVENTORY_ITEM_ID
1561: , iiac.RESOURCE_ID
1562: BULK COLLECT INTO inst_id, inv_org_id, inv_itm_id, res_id
1563: FROM CSL_CSI_ITEM_INSTANCES_ACC iiac
1564: , CSI_ITEM_INSTANCES ii
1565: , CSI_INSTANCE_STATUSES iis
1566: WHERE ii.INV_ORGANIZATION_ID IS NOT NULL
1567: AND ii.INV_SUBINVENTORY_NAME IS NOT NULL
1568: AND ii.INVENTORY_ITEM_ID IS NOT NULL

Line 1619: END CSL_CSI_ITEM_INSTANCES_ACC_PKG;

1615: END IF;
1616:
1617: END CONC_ITEM_INSTANCES;
1618:
1619: END CSL_CSI_ITEM_INSTANCES_ACC_PKG;