APPS.INV_GENEALOGY_REPORT_GEN dependencies on MFG_LOOKUPS

Line 516: From mfg_lookups

512: AND hou.organization_id = mp.organization_id;
513:
514: Cursor get_genealogy_type is
515: Select meaning
516: From mfg_lookups
517: where lookup_type='INV_REPORT_GENEALOGY_TYPE'
518: and lookup_code = g_genealogy_type;
519: Begin
520: debug('write query input');

Line 1012: From mfg_lookups

1008: From mtl_material_transactions
1009: Where transaction_id = l_orig_txn_id;
1010: Cursor get_txn_action_code IS
1011: Select meaning
1012: From mfg_lookups
1013: Where lookup_type = 'MTL_TRANSACTION_ACTION'
1014: and lookup_code = l_txn_action_id;
1015: */
1016:

Line 1114: FROM mfg_lookups

1110: ;
1111:
1112: Cursor get_intraoperation_step IS
1113: SELECT meaning
1114: FROM mfg_lookups
1115: WHERE lookup_type = 'WIP_INTRAOPERATION_STEP'
1116: and lookup_code = p_serial_attributes_rec.intraoperation_step_type;
1117:
1118: Begin

Line 1470: , mfg_lookups ml

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;
1474: else

Line 1645: , mfg_lookups ml

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;
1649: else