APPS.CSTPSCCM dependencies on CST_SC_ROLLUP_HISTORY

Line 126: CST_SC_ROLLUP_HISTORY has the correct information for the rollup_id

122: WHERE COST_TYPE_ID = p_buy_cost_type_id;
123:
124: /* The Who columns are not being correctly populated using FND_GLOBAL
125: structure.
126: CST_SC_ROLLUP_HISTORY has the correct information for the rollup_id
127: */
128: l_stmt_num := 2;
129:
130: select

Line 143: cst_sc_rollup_history

139: l_request_id,
140: l_prog_appl_id,
141: l_prog_id
142: from
143: cst_sc_rollup_history
144: where
145: rollup_id = p_rollup_id;
146:
147:

Line 861: FROM CST_SC_ROLLUP_HISTORY CSRH

857: -- SCAPI: delete data of previous reports including the consolidated report
858: DELETE CST_SC_BOM_STRUCTURES CSBS
859: WHERE CSBS.ROLLUP_ID IN (
860: SELECT CSRH.ROLLUP_ID
861: FROM CST_SC_ROLLUP_HISTORY CSRH
862: WHERE CSRH.ROLLUP_ID <> p_rollup_id
863: AND CSRH.COST_TYPE_ID = p_sc_cost_type_id
864: UNION
865: SELECT -1*CSRH.ROLLUP_ID

Line 866: FROM CST_SC_ROLLUP_HISTORY CSRH

862: WHERE CSRH.ROLLUP_ID <> p_rollup_id
863: AND CSRH.COST_TYPE_ID = p_sc_cost_type_id
864: UNION
865: SELECT -1*CSRH.ROLLUP_ID
866: FROM CST_SC_ROLLUP_HISTORY CSRH
867: WHERE CSRH.ROLLUP_ID <> p_rollup_id
868: AND CSRH.COST_TYPE_ID = p_sc_cost_type_id
869: )
870: AND (CSBS.COMPONENT_ITEM_ID,

Line 887: FROM CST_SC_ROLLUP_HISTORY CSRH

883:
884: DELETE CST_SC_BOM_EXPLOSION CSBE
885: WHERE CSBE.ROLLUP_ID IN (
886: SELECT CSRH.ROLLUP_ID
887: FROM CST_SC_ROLLUP_HISTORY CSRH
888: WHERE CSRH.ROLLUP_ID <> p_rollup_id
889: AND CSRH.COST_TYPE_ID = p_sc_cost_type_id)
890: AND (CSBE.COMPONENT_ITEM_ID,
891: CSBE.COMPONENT_ORGANIZATION_ID)

Line 907: FROM CST_SC_ROLLUP_HISTORY CSRH

903:
904: DELETE CST_SC_SOURCING_RULES CSSR
905: WHERE CSSR.ROLLUP_ID IN (
906: SELECT CSRH.ROLLUP_ID
907: FROM CST_SC_ROLLUP_HISTORY CSRH
908: WHERE CSRH.ROLLUP_ID <> p_rollup_id
909: AND CSRH.COST_TYPE_ID = p_sc_cost_type_id)
910: AND (CSSR.INVENTORY_ITEM_ID,
911: CSSR.ORGANIZATION_ID)

Line 927: FROM CST_SC_ROLLUP_HISTORY CSRH

923:
924: DELETE CST_SC_LOW_LEVEL_CODES CSLLC
925: WHERE CSLLC.ROLLUP_ID IN (
926: SELECT CSRH.ROLLUP_ID
927: FROM CST_SC_ROLLUP_HISTORY CSRH
928: WHERE CSRH.ROLLUP_ID <> p_rollup_id
929: AND CSRH.COST_TYPE_ID = p_sc_cost_type_id)
930: AND (CSLLC.INVENTORY_ITEM_ID,
931: CSLLC.ORGANIZATION_ID)

Line 944: FROM CST_SC_ROLLUP_HISTORY CSRH

940:
941: DELETE CST_SC_LISTS CSL
942: WHERE CSL.ROLLUP_ID IN (
943: SELECT CSRH.ROLLUP_ID
944: FROM CST_SC_ROLLUP_HISTORY CSRH
945: WHERE CSRH.ROLLUP_ID <> p_rollup_id
946: AND CSRH.COST_TYPE_ID = p_sc_cost_type_id)
947: AND (CSL.INVENTORY_ITEM_ID,
948: CSL.ORGANIZATION_ID)