APPS.WSMPGENE dependencies on MFG_LOOKUPS

Line 627: -- mfg_lookups lk,

623: SELECT
624: max(rj.transaction_id)
625: FROM
626: --bugfix 1796646, check status with error code '3', instead of with mfg_lookup
627: -- mfg_lookups lk,
628: wsm_split_merge_transactions tx,
629: wsm_sm_resulting_jobs rj
630: WHERE rj.wip_entity_id = wip_ent_id
631: AND rj.transaction_id < nvl(cur_trans_id,

Line 752: /* This procedure has been modified to get values from mfg_lookups */

748:
749: END issued_qty_o;
750:
751: /************************************************************************/
752: /* This procedure has been modified to get values from mfg_lookups */
753:
754: PROCEDURE wsm_inv_meaning_t(txn_id NUMBER,
755: tran_type OUT VARCHAR2,
756: wsm_inv_txn_type_id OUT NUMBER,

Line 764: FROM mfg_lookups ml, wsm_lot_split_merges sm

760:
761: CURSOR get_meaning IS
762:
763: SELECT ml.meaning,sm.transaction_type_id
764: FROM mfg_lookups ml, wsm_lot_split_merges sm
765: WHERE ml.lookup_type = 'WSM_INV_LOT_TXN_TYPE'
766: AND ml.lookup_code = sm.transaction_type_id
767: AND sm.transaction_id = txn_id;
768: