DBA Data[Home] [Help]

APPS.INV_GENEALOGY_REPORT_GEN dependencies on WSM_LOT_SPLIT_MERGES

Line 1473: from wsm_lot_split_merges wlsm

1469: and l_transaction_type_id in (32, 42) )
1470: then
1471: SELECT ml.meaning
1472: into p_material_txn_rec.TRANSACTION_TYPE
1473: from wsm_lot_split_merges wlsm
1474: , mfg_lookups ml
1475: where wlsm.transaction_id= l_source_line_id
1476: and ml.lookup_type='WSM_INV_LOT_TXN_TYPE'
1477: and ml.lookup_code=wlsm.transaction_type_id;

Line 1648: from wsm_lot_split_merges wlsm

1644: and l_transaction_type_id in (32, 42) )
1645: then
1646: SELECT ml.meaning
1647: into p_pending_txn_rec.TRANSACTION_TYPE
1648: from wsm_lot_split_merges wlsm
1649: , mfg_lookups ml
1650: where wlsm.transaction_id= l_source_line_id
1651: and ml.lookup_type='WSM_INV_LOT_TXN_TYPE'
1652: and ml.lookup_code=wlsm.transaction_type_id;