DBA Data[Home] [Help]

APPS.WIP_MOVE_VALIDATOR dependencies on MFG_LOOKUPS

Line 3050: from mfg_lookups lu,

3046: begin
3047: -- Should have at most one match
3048: select distinct lu.meaning
3049: into p_txn_type
3050: from mfg_lookups lu,
3051: mtl_material_transactions mmt
3052: where mmt.move_transaction_id = p_move_id
3053: and mmt.organization_id = l_org_id
3054: and mmt.transaction_source_id = l_wip_entity_id

Line 3064: from mfg_lookups

3060: -- no inv txn involved; just a plain move txn
3061: when no_data_found then
3062: select meaning
3063: into p_txn_type
3064: from mfg_lookups
3065: where lookup_type = 'WIP_MOVE_TRANSACTION_TYPE'
3066: and lookup_code = wip_constants.move_txn;
3067: when others then
3068: p_txn_type := -1;