[Home] [Help]
21: Added column Interface_Line_Attribute2 column in Cursor GET_SUPP_INV_LINES
22:
23: 07/12/2005 Hjujjuru for the bug 4866533 File version 120.3
24: added the who columns in the insert commands for the tables
25: JAI_AR_SUP_INV_T and JAI_AR_TRX_SUP_INV_T.
26: Dependencies Due to this bug:-
27: None
28:
29: 27-Dec-2005 Bug 4906958. Added by Lakshmi Gopalsami Version 120.6
92:
93: /* Added by Ramananda for bug#4407165 */
94: lv_object_name CONSTANT VARCHAR2(61) := 'jai_ar_sup_trx_pkg.identify_invoices';
95:
96: CURSOR CH(N NUMBER,M VARCHAR2) IS SELECT 1 FROM JAI_AR_TRX_SUP_INV_T WHERE CUSTOMER_TRX_ID = N
97: AND MAPPING_TYPE = M;
98:
99: Cursor ch_tax(id number,tax_name number) is select 1 from JAI_AR_TRX_SUP_INV_T where customer_trx_id = id
100: and mapping_type = 'T'
95:
96: CURSOR CH(N NUMBER,M VARCHAR2) IS SELECT 1 FROM JAI_AR_TRX_SUP_INV_T WHERE CUSTOMER_TRX_ID = N
97: AND MAPPING_TYPE = M;
98:
99: Cursor ch_tax(id number,tax_name number) is select 1 from JAI_AR_TRX_SUP_INV_T where customer_trx_id = id
100: and mapping_type = 'T'
101: and existing_type_id = tax_name;
102:
103: -- CURSOR FOR SELECTING ENTRIES FROM THE MASTER TABLE JAI_AR_SUP_CHANGES_ALL WHOSE PROCESS DATE IS NOT NULL --
349:
350: IF I.INTERFACE_HEADER_CONTEXT LIKE '%ORDER%'
351: AND J.MAPPING_TYPE LIKE 'P' THEN
352:
353: INSERT INTO JAI_AR_TRX_SUP_INV_T
354: (CUSTOMER_TRX_ID,
355: EXISTING_TYPE_ID,
356: NEW_TYPE_ID,
357: MAPPING_TYPE,
405: )
406: AND J.MAPPING_TYPE LIKE 'I' THEN
407:
408:
409: INSERT INTO JAI_AR_TRX_SUP_INV_T
410: (CUSTOMER_TRX_ID,
411: EXISTING_TYPE_ID,
412: NEW_TYPE_ID,
413: MAPPING_TYPE,
452: END IF;
453: IF J.MAPPING_TYPE IN ('T','A') THEN
454:
455:
456: INSERT INTO JAI_AR_TRX_SUP_INV_T
457: (CUSTOMER_TRX_ID,
458: EXISTING_TYPE_ID,
459: NEW_TYPE_ID,
460: MAPPING_TYPE,
602: v_assessable_list_id NUMBER;
603:
604: CURSOR FETCH_CMB_TAB_INV IS
605: SELECT A.*, B.BATCH_ID
606: FROM JAI_AR_TRX_SUP_INV_T A,
607: JAI_AR_SUP_CHANGES_ALL B
608: WHERE A.MAPPING_ID = B.MAPPING_ID
609: ORDER BY CUSTOMER_TRX_ID;
610:
649: ,b.global_attribute_category --Added by zhiwei for Bug#12615714
650: FROM ra_customer_trx_all a,
651: ra_customer_trx_lines_all b,
652: mtl_system_items c,
653: jai_ar_trx_sup_inv_t d, -- added by sriram - bug # 3143813 - 19/09/2003
654: jai_ar_trxs jat /* added the table and join condition - aiyer for the fwd porting bug 5225768*/
655: WHERE a.customer_trx_id = b.customer_trx_id
656: AND b.inventory_item_id = c.inventory_item_id
657: --AND c.organization_id = b.warehouse_id
1057: OAMOUNT := ASELLING_PRICE*AQUANTITY;
1058:
1059: SELECT DISTINCT CUSTOMER_TRX_ID, EXISTING_TYPE_ID, NEW_TYPE_ID, Mapping_id
1060: INTO P_CUSTOMER_TRX_ID, P_EXISTING_TYPE_ID, P_NEW_TYPE_ID, v_p_mapping_id
1061: FROM JAI_AR_TRX_SUP_INV_T
1062: WHERE MAPPING_TYPE = 'P'
1063: AND CUSTOMER_TRX_ID = FETCH_INV.CUSTOMER_TRX_ID;
1064:
1065: v_statement_id := '12';
1244:
1245: v_statement_id := '27';
1246: SELECT CUSTOMER_TRX_ID, NEW_TYPE_ID, mapping_id
1247: INTO I_CUSTOMER_TRX_ID, I_NEW_TYPE_ID, v_i_mapping_id
1248: FROM JAI_AR_TRX_SUP_INV_T
1249: WHERE MAPPING_TYPE = 'I'
1250: AND CUSTOMER_TRX_ID = FETCH_INV.CUSTOMER_TRX_ID;
1251:
1252: v_statement_id := '28';
1414:
1415: v_statement_id := '46';
1416: SELECT CUSTOMER_TRX_ID, EXISTING_TYPE_ID, NEW_TYPE_ID, mapping_id
1417: INTO A_CUSTOMER_TRX_ID, A_EXISTING_TYPE_ID, A_NEW_TYPE_ID, v_a_mapping_id
1418: FROM JAI_AR_TRX_SUP_INV_T
1419: WHERE MAPPING_TYPE = 'A'
1420: AND CUSTOMER_TRX_ID = FETCH_INV.CUSTOMER_TRX_ID;
1421:
1422:
1489: AND TEMP.TAX_ID = COD.TAX_ID;
1490:
1491: CURSOR GET_INV_TAX IS
1492: SELECT EXISTING_TYPE_ID, NEW_TYPE_ID, MAPPING_ID
1493: FROM JAI_AR_TRX_SUP_INV_T
1494: WHERE MAPPING_TYPE = 'T'
1495: AND CUSTOMER_TRX_ID = FETCH_INV.CUSTOMER_TRX_ID;
1496:
1497: BEGIN
1933:
1934:
1935:
1936: v_statement_id := '97';
1937: DELETE JAI_AR_TRX_SUP_INV_T;
1938:
1939: v_statement_id := '98';
1940: DELETE JAI_AR_SUP_INV_T;
1941: