APPS.CST_SUBELEMENTS_PVT dependencies on CST_ITEM_CST_DTLS_INTERFACE

Line 301: from cst_item_cst_dtls_interface cicdi

297:
298: CURSOR C_from_subelements IS
299: /* Bug 5443502: added cost_element_id in the select */
300: select distinct cicdi.resource_code, cicdi.cost_element_id
301: from cst_item_cst_dtls_interface cicdi
302: where cicdi.group_id = p_group_id
303: and cicdi.resource_code is not null
304: UNION
305: select distinct basis_resource_code, cost_element_id

Line 306: from cst_item_cst_dtls_interface

302: where cicdi.group_id = p_group_id
303: and cicdi.resource_code is not null
304: UNION
305: select distinct basis_resource_code, cost_element_id
306: from cst_item_cst_dtls_interface
307: where group_id = p_group_id
308: and basis_resource_code is not null;
309:
310: CURSOR C_from_departments IS

Line 312: from cst_item_cst_dtls_interface

308: and basis_resource_code is not null;
309:
310: CURSOR C_from_departments IS
311: select distinct department
312: from cst_item_cst_dtls_interface
313: where group_id = p_group_id
314: and department is not null;
315:
316: CURSOR C_from_activity IS

Line 318: from cst_item_cst_dtls_interface

314: and department is not null;
315:
316: CURSOR C_from_activity IS
317: select distinct activity
318: from cst_item_cst_dtls_interface
319: where group_id = p_group_id
320: and activity is not null;
321:
322:

Line 2437: UPDATE CST_ITEM_CST_DTLS_INTERFACE CICDI

2433:
2434: -- Convert to Item Basis Type for non-matching subelements
2435: -- Update the resource_id and resource_code to -1 for future deletion
2436:
2437: UPDATE CST_ITEM_CST_DTLS_INTERFACE CICDI
2438: SET
2439: operation_sequence_id = NULL, --operation_sequence_id,
2440: operation_seq_num = NULL, --operation_seq_num,
2441: department_id = NULL, --department_id,

Line 2478: UPDATE CST_ITEM_CST_DTLS_INTERFACE CICDI

2474: l_statement := 104;
2475: -- Convert to Item Basis Type
2476: -- Update the resource_id and resource_code to -1 for future deletion
2477:
2478: UPDATE CST_ITEM_CST_DTLS_INTERFACE CICDI
2479: SET
2480: operation_sequence_id = NULL, --operation_sequence_id,
2481: operation_seq_num = NULL, --operation_seq_num,
2482: department_id = NULL, --department_id,

Line 2520: UPDATE CST_ITEM_CST_DTLS_INTERFACE CICDI

2516:
2517: -- Convert to Item Basis Type for non-matching subelements
2518: -- Update the resource_id and resource_code to -1 for future deletion
2519:
2520: UPDATE CST_ITEM_CST_DTLS_INTERFACE CICDI
2521: SET
2522: operation_sequence_id = NULL, --operation_sequence_id,
2523: operation_seq_num = NULL, --operation_seq_num,
2524: department_id = NULL, --department_id,

Line 2563: UPDATE CST_ITEM_CST_DTLS_INTERFACE CICDI

2559:
2560:
2561: l_statement := 109;
2562:
2563: UPDATE CST_ITEM_CST_DTLS_INTERFACE CICDI
2564: SET
2565: operation_sequence_id = NULL, --operation_sequence_id,
2566: operation_seq_num = NULL, --operation_seq_num,
2567: department_id = NULL, --department_id,

Line 2603: UPDATE CST_ITEM_CST_DTLS_INTERFACE CICDI

2599:
2600: -- Convert to Item Basis Type for all subelements
2601: -- Update the resource_id and resource_code to -1 for future deletion
2602:
2603: UPDATE CST_ITEM_CST_DTLS_INTERFACE CICDI
2604: SET
2605: operation_sequence_id = NULL, --operation_sequence_id,
2606: operation_seq_num = NULL, --operation_seq_num,
2607: department_id = NULL, --department_id,

Line 2635: INSERT INTO CST_ITEM_CST_DTLS_INTERFACE

2631: l_statement := 115;
2632:
2633: -- Create summarized rows for every default subelement
2634:
2635: INSERT INTO CST_ITEM_CST_DTLS_INTERFACE
2636: (
2637: INVENTORY_ITEM_ID, -- NUMBER
2638: COST_TYPE_ID, -- NOT NULL NUMBER
2639: LAST_UPDATE_DATE, -- DATE

Line 2768: FROM CST_ITEM_CST_DTLS_INTERFACE CICDI2

2764: NULL, -- PROCESS_FLAG
2765: NULL, -- ITEM_NUMBER
2766: NULL, -- TRANSACTION_TYPE
2767: SUM(CICDI2.YIELDED_COST)
2768: FROM CST_ITEM_CST_DTLS_INTERFACE CICDI2
2769: WHERE CICDI2.GROUP_ID = p_group_id
2770: AND CICDI2.RESOURCE_CODE = '-1'
2771: AND CICDI2.RESOURCE_ID = -1
2772: GROUP BY

Line 2786: DELETE CST_ITEM_CST_DTLS_INTERFACE CICDI

2782: l_statement := 120;
2783:
2784: -- Delete all rows with resource_code and resourde_id = -1
2785:
2786: DELETE CST_ITEM_CST_DTLS_INTERFACE CICDI
2787: WHERE CICDI.RESOURCE_CODE = '-1'
2788: AND CICDI.RESOURCE_ID = -1
2789: AND CICDI.GROUP_ID = p_group_id;
2790:

Line 2798: FROM CST_ITEM_CST_DTLS_INTERFACE CICDI

2794: /* ***** Rows generated bacause of missing default subelemnts ***** */
2795:
2796: SELECT COUNT(*)
2797: INTO l_miss_def_subelem
2798: FROM CST_ITEM_CST_DTLS_INTERFACE CICDI
2799: WHERE CICDI.RESOURCE_CODE = '-1'
2800: AND CICDI.RESOURCE_ID IS NULL
2801: AND CICDI.GROUP_ID = p_group_id;
2802: