DBA Data[Home] [Help]

APPS.GME_MOBILE_TXN dependencies on MTL_SYSTEM_ITEMS_KFV

Line 569: FROM mtl_system_items_kfv

565: WHERE transaction_type_id = p_transaction_type_id;
566:
567: SELECT substr(concatenated_segments,1,100)
568: INTO l_item
569: FROM mtl_system_items_kfv
570: WHERE organization_id = p_organization_id
571: AND inventory_item_id = p_inventory_item_id;
572:
573: IF p_object_type = 'O' THEN --- Lot

Line 2999: FROM mtl_system_items_kfv

2995: CURSOR Get_div_flag IS
2996: SELECT
2997: NVL(lot_divisible_flag, 'N'),
2998: NVL(lot_control_code, 1)
2999: FROM mtl_system_items_kfv
3000: WHERE inventory_item_id = p_item_id
3001: AND organization_id = p_organization_id;
3002:
3003: l_lot_div_flag VARCHAR2(1);