DBA Data[Home] [Help]

APPS.INL_SHIPMENT_PVT dependencies on INL_ALLOCATIONS

Line 597: FROM inl_allocations cfa

593: l_debug_info VARCHAR2 (200) ;
594: BEGIN
595: -- Verify if there is allocation for Shipment
596: DELETE
597: FROM inl_allocations cfa
598: WHERE cfa.ship_header_id = p_ship_header_id
599: AND NOT EXISTS
600: (
601: SELECT 'x'

Line 602: FROM inl_allocations al1

598: WHERE cfa.ship_header_id = p_ship_header_id
599: AND NOT EXISTS
600: (
601: SELECT 'x'
602: FROM inl_allocations al1
603: WHERE al1.ship_header_id = cfa.ship_header_id
604: AND al1.adjustment_num > 0
605: AND ROWNUM < 2
606: ) ;

Line 12211: FROM inl_allocations;

12207: p_debug_info => l_debug_info
12208: ) ;
12209: SELECT MAX(allocation_id)
12210: INTO l_max_allocation_id
12211: FROM inl_allocations;
12212:
12213: INL_LOGGING_PVT.Log_Variable (
12214: p_module_name => g_module_name,
12215: p_procedure_name => l_api_name,