APPS.INV_GENEALOGY_REPORT_GEN dependencies on MFG_LOOKUPS

Line 520: From mfg_lookups

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

Line 1016: From mfg_lookups

1012: From mtl_material_transactions
1013: Where transaction_id = l_orig_txn_id;
1014: Cursor get_txn_action_code IS
1015: Select meaning
1016: From mfg_lookups
1017: Where lookup_type = 'MTL_TRANSACTION_ACTION'
1018: and lookup_code = l_txn_action_id;
1019: */
1020:

Line 1118: FROM mfg_lookups

1114: ;
1115:
1116: Cursor get_intraoperation_step IS
1117: SELECT meaning
1118: FROM mfg_lookups
1119: WHERE lookup_type = 'WIP_INTRAOPERATION_STEP'
1120: and lookup_code = p_serial_attributes_rec.intraoperation_step_type;
1121:
1122: Begin

Line 1474: , mfg_lookups ml

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

Line 1649: , mfg_lookups ml

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