DBA Data[Home] [Help]

APPS.CSTPLCWP dependencies on CST_COMP_SNAPSHOT

Line 101: UPDATE cst_comp_snapshot cocd1

97: of creation due to constraints in Iventory
98: transaction manager
99: */
100: IF ( l_action_id IN (30,31,32) ) THEN
101: UPDATE cst_comp_snapshot cocd1
102: SET
103: (cocd1.prior_completion_quantity, cocd1.prior_scrap_quantity) =
104: (SELECT
105: NVL

Line 120: cst_comp_snapshot cocd2,

116: cocd2.primary_quantity)
117: ),
118: 0)
119: FROM
120: cst_comp_snapshot cocd2,
121: mtl_material_transactions mmt
122: WHERE cocd2.transaction_id = mmt.transaction_id
123: AND cocd2.wip_entity_id = cocd1.wip_entity_id
124: AND cocd2.operation_seq_num = cocd1.operation_seq_num