APPS.CSTPSMCW dependencies on WSM_SPLIT_MERGE_TRANSACTIONS

Line 78: FROM wsm_split_merge_transactions

74: SELECT transaction_id,
75: transaction_type_id,
76: organization_id,
77: transaction_date
78: FROM wsm_split_merge_transactions
79: WHERE costed = WIP_CONSTANTS.PENDING
80: AND status = WIP_CONSTANTS.COMPLETED
81: AND organization_id = p_org_id
82: AND group_id = p_group_id

Line 164: UPDATE wsm_split_merge_transactions

160: These have no costing impact */
161:
162: l_stmt_num := 50;
163:
164: UPDATE wsm_split_merge_transactions
165: SET costed = WIP_CONSTANTS.COMPLETED
166: WHERE transaction_type_id in (3,5,7)
167: AND costed = WIP_CONSTANTS.PENDING
168: AND status = WIP_CONSTANTS.COMPLETED

Line 183: wsm_split_merge_transactions wsmt

179: scans */
180: SELECT count(*)
181: INTO l_txn_mmt_flag
182: FROM mtl_material_transactions mmt,
183: wsm_split_merge_transactions wsmt
184: WHERE
185: (transaction_source_id in
186: (select wip_entity_id
187: from wsm_sm_resulting_jobs wsrj

Line 217: FROM WSM_SPLIT_MERGE_TRANSACTIONS

213:
214: -- FIND TRANSACTION_TYPE
215: SELECT TRANSACTION_TYPE_ID
216: INTO l_txn_type_id
217: FROM WSM_SPLIT_MERGE_TRANSACTIONS
218: WHERE transaction_id = c_uncost_rec.transaction_id;
219:
220: -- Update
221: IF ( l_debug_flag = 'Y' ) THEN

Line 317: -- This function updates WSM_SPLIT_MERGE_TRANSACTIONS with the status --

313: -- FUNCTION --
314: -- UPDATE_WSMT_TXN_STATUS --
315: -- --
316: -- DESCRIPTION --
317: -- This function updates WSM_SPLIT_MERGE_TRANSACTIONS with the status --
318: -- of the costed column (COSTED/ERROR) --
319: -- PURPOSE: --
320: -- OSFM Lot Transactions Costing for Oracle Applications Rel 11i.8
321: -- --

Line 342: UPDATE wsm_split_merge_transactions

338: p_prog_id IN NUMBER )
339: RETURN BOOLEAN IS
340: BEGIN
341:
342: UPDATE wsm_split_merge_transactions
343: SET costed = p_costed,
344: error_message = p_error_message,
345: request_id = p_request_id,
346: program_application_id = p_prog_appl_id,

Line 496: UPDATE wsm_split_merge_transactions txn

492: JOB_OPERATION_SEQ_NUM populated */
493:
494: l_stmt_num := 40;
495:
496: UPDATE wsm_split_merge_transactions txn
497: SET costed = WIP_CONSTANTS.COMPLETED
498: WHERE transaction_type_id = 4
499: AND transaction_id = l_wsmt_transaction_id /* Added for bug 5008413 */
500: AND costed = WIP_CONSTANTS.PENDING