DBA Data[Home] [Help]

APPS.WSMPGENE dependencies on WSM_SPLIT_MERGE_TRANSACTIONS

Line 628: wsm_split_merge_transactions tx,

624: max(rj.transaction_id)
625: FROM
626: --bugfix 1796646, check status with error code '3', instead of with mfg_lookup
627: -- mfg_lookups lk,
628: wsm_split_merge_transactions tx,
629: wsm_sm_resulting_jobs rj
630: WHERE rj.wip_entity_id = wip_ent_id
631: AND rj.transaction_id < nvl(cur_trans_id,
632: rj.transaction_id + 1)

Line 816: FROM wsm_split_merge_transactions

812: x_err_msg OUT VARCHAR2) IS
813: CURSOR get_type_id IS
814: SELECT
815: transaction_type_id
816: FROM wsm_split_merge_transactions
817: WHERE transaction_id = id;
818: BEGIN
819: OPEN get_type_id;
820: FETCH get_type_id INTO type_id;