APPS.CSTPACMS dependencies on CST_COMP_SNAPSHOT

Line 18: Transfer info from cst_comp_snap_temp to cst_comp_snapshot

14: BEGIN
15: stmt_num := 10;
16:
17: /*
18: Transfer info from cst_comp_snap_temp to cst_comp_snapshot
19: with transaction_id from MTL_MATERIAL_TRANSACTIONS
20: */
21: INSERT INTO cst_comp_snapshot
22: (transaction_id,

Line 21: INSERT INTO cst_comp_snapshot

17: /*
18: Transfer info from cst_comp_snap_temp to cst_comp_snapshot
19: with transaction_id from MTL_MATERIAL_TRANSACTIONS
20: */
21: INSERT INTO cst_comp_snapshot
22: (transaction_id,
23: wip_entity_id,
24: operation_seq_num,
25: last_update_date,

Line 80: UPDATE cst_comp_snapshot cocd1

76: as the sum of previous primary_quantity of
77: all the previous transactions of the same job and
78: same operation
79: */
80: UPDATE cst_comp_snapshot cocd1
81: SET
82: (prior_completion_quantity, prior_scrap_quantity) =
83: (SELECT
84: NVL

Line 99: cst_comp_snapshot cocd2,

95: cocd2.primary_quantity)
96: ),
97: 0)
98: FROM
99: cst_comp_snapshot cocd2,
100: mtl_material_transactions mmt
101: WHERE
102: cocd2.transaction_id < cocd1.transaction_id
103: AND cocd2.transaction_id = mmt.transaction_id

Line 115: FROM cst_comp_snapshot cocd3

111: AND
112: EXISTS
113: (
114: SELECT 'x'
115: FROM cst_comp_snapshot cocd3
116: WHERE
117: cocd3.transaction_id < l_txn_id
118: AND cocd3.wip_entity_id = cocd1.wip_entity_id
119: AND cocd3.operation_seq_num = cocd1.operation_seq_num

Line 125: * Update cst_comp_snapshot

121:
122: stmt_num := 40;
123:
124: /*
125: * Update cst_comp_snapshot
126: * by setting new_operation_flag to 1
127: * if it is a new operation
128: * ie. operation_seq_num is smaller than the latter ones
129: * but the quantity_completed is also smaller.

Line 131: UPDATE cst_comp_snapshot cocd1

127: * if it is a new operation
128: * ie. operation_seq_num is smaller than the latter ones
129: * but the quantity_completed is also smaller.
130: */
131: UPDATE cst_comp_snapshot cocd1
132: SET
133: new_operation_flag = 1
134: WHERE
135: cocd1.transaction_id = l_txn_id

Line 139: cst_comp_snapshot cocd2,

135: cocd1.transaction_id = l_txn_id
136: AND cocd1.operation_seq_num IN
137: (SELECT cocd2.operation_seq_num
138: FROM
139: cst_comp_snapshot cocd2,
140: cst_comp_snapshot cocd3
141: WHERE
142: cocd2.transaction_id = l_txn_id
143: AND cocd2.transaction_id = cocd3.transaction_id

Line 140: cst_comp_snapshot cocd3

136: AND cocd1.operation_seq_num IN
137: (SELECT cocd2.operation_seq_num
138: FROM
139: cst_comp_snapshot cocd2,
140: cst_comp_snapshot cocd3
141: WHERE
142: cocd2.transaction_id = l_txn_id
143: AND cocd2.transaction_id = cocd3.transaction_id
144: AND cocd2.operation_seq_num < cocd3.operation_seq_num