[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
80:
81: /* Added by Ramananda for bug#4407165 */
82: lv_object_name CONSTANT VARCHAR2(61) := 'jai_ar_sup_trx_pkg.identify_invoices';
83:
84: CURSOR CH(N NUMBER,M VARCHAR2) IS SELECT 1 FROM JAI_AR_TRX_SUP_INV_T WHERE CUSTOMER_TRX_ID = N
85: AND MAPPING_TYPE = M;
86:
87: Cursor ch_tax(id number,tax_name number) is select 1 from JAI_AR_TRX_SUP_INV_T where customer_trx_id = id
88: and mapping_type = 'T'
83:
84: CURSOR CH(N NUMBER,M VARCHAR2) IS SELECT 1 FROM JAI_AR_TRX_SUP_INV_T WHERE CUSTOMER_TRX_ID = N
85: AND MAPPING_TYPE = M;
86:
87: Cursor ch_tax(id number,tax_name number) is select 1 from JAI_AR_TRX_SUP_INV_T where customer_trx_id = id
88: and mapping_type = 'T'
89: and existing_type_id = tax_name;
90:
91: -- CURSOR FOR SELECTING ENTRIES FROM THE MASTER TABLE JAI_AR_SUP_CHANGES_ALL WHOSE PROCESS DATE IS NOT NULL --
288: and i.customer_site = nvl(j.site_use_id,i.customer_site) then
289: IF I.INTERFACE_HEADER_CONTEXT LIKE '%ORDER%'
290: AND J.MAPPING_TYPE LIKE 'P' THEN
291:
292: INSERT INTO JAI_AR_TRX_SUP_INV_T
293: (CUSTOMER_TRX_ID,
294: EXISTING_TYPE_ID,
295: NEW_TYPE_ID,
296: MAPPING_TYPE,
336: IF I.INTERFACE_HEADER_CONTEXT IS NULL
337: AND J.MAPPING_TYPE LIKE 'I' THEN
338:
339:
340: INSERT INTO JAI_AR_TRX_SUP_INV_T
341: (CUSTOMER_TRX_ID,
342: EXISTING_TYPE_ID,
343: NEW_TYPE_ID,
344: MAPPING_TYPE,
383: END IF;
384: IF J.MAPPING_TYPE IN ('T','A') THEN
385:
386:
387: INSERT INTO JAI_AR_TRX_SUP_INV_T
388: (CUSTOMER_TRX_ID,
389: EXISTING_TYPE_ID,
390: NEW_TYPE_ID,
391: MAPPING_TYPE,
532: v_assessable_list_id NUMBER;
533:
534: CURSOR FETCH_CMB_TAB_INV IS
535: SELECT A.*, B.BATCH_ID
536: FROM JAI_AR_TRX_SUP_INV_T A,
537: JAI_AR_SUP_CHANGES_ALL B
538: WHERE A.MAPPING_ID = B.MAPPING_ID
539: ORDER BY CUSTOMER_TRX_ID;
540:
578: a.invoice_currency_code
579: FROM ra_customer_trx_all a,
580: ra_customer_trx_lines_all b,
581: mtl_system_items c,
582: jai_ar_trx_sup_inv_t d, -- added by sriram - bug # 3143813 - 19/09/2003
583: jai_ar_trxs jat /* added the table and join condition - aiyer for the fwd porting bug 5225768*/
584: WHERE a.customer_trx_id = b.customer_trx_id
585: AND b.inventory_item_id = c.inventory_item_id
586: --AND c.organization_id = b.warehouse_id
956: OAMOUNT := ASELLING_PRICE*AQUANTITY;
957:
958: SELECT DISTINCT CUSTOMER_TRX_ID, EXISTING_TYPE_ID, NEW_TYPE_ID, Mapping_id
959: INTO P_CUSTOMER_TRX_ID, P_EXISTING_TYPE_ID, P_NEW_TYPE_ID, v_p_mapping_id
960: FROM JAI_AR_TRX_SUP_INV_T
961: WHERE MAPPING_TYPE = 'P'
962: AND CUSTOMER_TRX_ID = FETCH_INV.CUSTOMER_TRX_ID;
963:
964: v_statement_id := '12';
1133:
1134: v_statement_id := '27';
1135: SELECT CUSTOMER_TRX_ID, NEW_TYPE_ID, mapping_id
1136: INTO I_CUSTOMER_TRX_ID, I_NEW_TYPE_ID, v_i_mapping_id
1137: FROM JAI_AR_TRX_SUP_INV_T
1138: WHERE MAPPING_TYPE = 'I'
1139: AND CUSTOMER_TRX_ID = FETCH_INV.CUSTOMER_TRX_ID;
1140:
1141: v_statement_id := '28';
1296:
1297: v_statement_id := '46';
1298: SELECT CUSTOMER_TRX_ID, EXISTING_TYPE_ID, NEW_TYPE_ID, mapping_id
1299: INTO A_CUSTOMER_TRX_ID, A_EXISTING_TYPE_ID, A_NEW_TYPE_ID, v_a_mapping_id
1300: FROM JAI_AR_TRX_SUP_INV_T
1301: WHERE MAPPING_TYPE = 'A'
1302: AND CUSTOMER_TRX_ID = FETCH_INV.CUSTOMER_TRX_ID;
1303:
1304:
1371: AND TEMP.TAX_ID = COD.TAX_ID;
1372:
1373: CURSOR GET_INV_TAX IS
1374: SELECT EXISTING_TYPE_ID, NEW_TYPE_ID, MAPPING_ID
1375: FROM JAI_AR_TRX_SUP_INV_T
1376: WHERE MAPPING_TYPE = 'T'
1377: AND CUSTOMER_TRX_ID = FETCH_INV.CUSTOMER_TRX_ID;
1378:
1379: BEGIN
1805:
1806:
1807:
1808: v_statement_id := '97';
1809: DELETE JAI_AR_TRX_SUP_INV_T;
1810:
1811: v_statement_id := '98';
1812: DELETE JAI_AR_SUP_INV_T;
1813: