DBA Data[Home] [Help]

APPS.GME_MOBILE_TXN dependencies on MTL_SYSTEM_ITEMS_KFV

Line 660: FROM mtl_system_items_kfv

656: WHERE transaction_type_id = p_transaction_type_id;
657:
658: SELECT substr(concatenated_segments,1,100)
659: INTO l_item
660: FROM mtl_system_items_kfv
661: WHERE organization_id = p_organization_id
662: AND inventory_item_id = p_inventory_item_id;
663:
664: IF p_object_type = 'O' THEN --- Lot

Line 3095: FROM mtl_system_items_kfv

3091: CURSOR Get_div_flag IS
3092: SELECT
3093: NVL(lot_divisible_flag, 'N'),
3094: NVL(lot_control_code, 1)
3095: FROM mtl_system_items_kfv
3096: WHERE inventory_item_id = p_item_id
3097: AND organization_id = p_organization_id;
3098:
3099: l_lot_div_flag VARCHAR2(1);