DBA Data[Home] [Help]

APPS.WSMPGENE dependencies on WSM_SM_RESULTING_LOTS

Line 186: FROM wsm_sm_resulting_lots

182: THEN inv_or_wip := 'INV';
183: SELECT
184: wip_entity_id
185: INTO next_trans_id
186: FROM wsm_sm_resulting_lots
187: WHERE transaction_id = next_trans_ref;
188:
189: /* ELSIF txn_type = 'SubXsfer' */
190: ELSIF txn_type_id = 4

Line 410: wsm_sm_resulting_lots result

406: SELECT
407: starting.subinventory_code,
408: result.subinventory_code
409: FROM wsm_sm_starting_lots starting,
410: wsm_sm_resulting_lots result
411: WHERE starting.transaction_id = trans_id
412: AND result.transaction_id = trans_id;
413: BEGIN
414: OPEN get_info;