DBA Data[Home] [Help]

APPS.INV_GENEALOGY_REPORT_GEN dependencies on WSM_LOT_SPLIT_MERGES

Line 1469: from wsm_lot_split_merges wlsm

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

Line 1644: from wsm_lot_split_merges wlsm

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