DBA Data[Home] [Help]

APPS.INL_INTERFACE_PVT dependencies on AP_INVOICE_DISTRIBUTIONS

Line 3614: FROM ap_invoice_distributions d,

3610: INTO l_line_type_lookup_code,
3611: l_org_id,
3612: l_inventory_item_id,
3613: l_match_type
3614: FROM ap_invoice_distributions d,
3615: ap_invoice_lines l
3616: WHERE d.invoice_distribution_id = p_from_parent_table_id
3617: AND d.invoice_id = l.invoice_id
3618: AND d.invoice_line_number = l.line_number

Line 4154: IF matchesToProcess_List(iMatch).from_parent_table_name = 'AP_INVOICE_DISTRIBUTIONS'

4150: IF NVL(matchesToProcess_List.LAST, 0) > 0 THEN
4151: FOR iMatch IN matchesToProcess_List.FIRST..matchesToProcess_List.LAST
4152: LOOP
4153:
4154: IF matchesToProcess_List(iMatch).from_parent_table_name = 'AP_INVOICE_DISTRIBUTIONS'
4155: THEN
4156: l_matched_qty := matchesToProcess_List(iMatch).matched_qty ;
4157: l_matched_uom_code := matchesToProcess_List(iMatch).matched_uom_code ;
4158: l_new_to_parent_table_name := matchesToProcess_List(iMatch).to_parent_table_name ;

Line 6302: AND p_to_parent_table_name IN('AP_INVOICE_DISTRIBUTIONS')

6298: AND p_to_parent_table_name IN('INL_SHIP_LINES_INT',
6299: 'INL_SHIP_HEADERS_INT')
6300: )
6301: OR(p_match_type_code = 'CORRECTION'
6302: AND p_to_parent_table_name IN('AP_INVOICE_DISTRIBUTIONS')
6303: )
6304: THEN
6305: l_nameOk := 'Y';
6306: BEGIN