APPS.CLN_SYNC_ITEM_PKG dependencies on CST_ITEM_CST_DTLS_INTERFACE

Line 1784: INSERT INTO CST_ITEM_CST_DTLS_INTERFACE

1780: END IF;
1781:
1782:
1783: -- INSERTION OF THE DATA IN THE COSTING INTERFACE TABLE
1784: INSERT INTO CST_ITEM_CST_DTLS_INTERFACE
1785: (
1786: INVENTORY_ITEM_ID,
1787: ORGANIZATION_ID,
1788: RESOURCE_ID,

Line 2102: FROM cst_item_cst_dtls_interface cicdi

2098: INTO l_count_failed_rows
2099: FROM dual
2100: WHERE exists
2101: ( SELECT 'x'
2102: FROM cst_item_cst_dtls_interface cicdi
2103: WHERE error_flag = 'E'
2104: AND group_id = l_cst_group_id
2105: AND rownum < 2
2106: );

Line 2199: ||' FROM CST_ITEM_CST_DTLS_INTERFACE'

2195: -- find out the item number from the query below.
2196: -- this is reqd for the showing in final event details screen
2197:
2198: sql_statement_error_msg := ' SELECT ERROR_EXPLANATION, ITEM_NUMBER'
2199: ||' FROM CST_ITEM_CST_DTLS_INTERFACE'
2200: ||' WHERE ORGANIZATION_ID = '||l_master_organization_id
2201: ||' AND GROUP_ID = '||l_cst_group_id
2202: ||' AND ERROR_EXPLANATION IS NOT NULL';
2203: