DBA Data[Home] [Help]

APPS.CSTPACWP dependencies on CST_COMP_SNAPSHOT

Line 115: UPDATE cst_comp_snapshot cocd1

111: transaction manager
112: */
113: IF ( l_action_id IN (30,31,32) ) THEN
114: stmt_num := 15;
115: UPDATE cst_comp_snapshot cocd1
116: SET
117: (cocd1.prior_completion_quantity, cocd1.prior_scrap_quantity) =
118: (SELECT
119: NVL

Line 134: cst_comp_snapshot cocd2,

130: cocd2.primary_quantity)
131: ),
132: 0)
133: FROM
134: cst_comp_snapshot cocd2,
135: mtl_material_transactions mmt
136: WHERE cocd2.transaction_id = mmt.transaction_id
137: AND cocd2.wip_entity_id = cocd1.wip_entity_id
138: AND cocd2.operation_seq_num = cocd1.operation_seq_num