eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JMF_GTA_TXT_OPERATOR_PROC dependencies on JMF_GTA_TRX_HEADERS

Line 151: TYPE c_trx_header_id_type IS REF CURSOR RETURN jmf_gta_trx_headers%ROWTYPE;

147: --+======================================================================*/
148:
149: --TYPE COLUMN_VALUES IS TABLE OF VARCHAR2(200);
150: TYPE t_invoice_export_output IS TABLE OF VARCHAR2(5000);
151: TYPE c_trx_header_id_type IS REF CURSOR RETURN jmf_gta_trx_headers%ROWTYPE;
152:
153: --===================
154: -- CONSTANTS
155: --===================

Line 524: L_HEADER_ID Jmf_Gta_Trx_Headers_All.Gta_Trx_Header_Id%TYPE;

520: --===========================================================================
521: PROCEDURE Import_Invoices
522: IS
523: l_procedure_name VARCHAR2(30):='Import_invoices';
524: L_HEADER_ID Jmf_Gta_Trx_Headers_All.Gta_Trx_Header_Id%TYPE;
525: l_line_seq NUMBER;
526: l_values COLUMN_VALUES:=COLUMN_VALUES(NULL);
527: l_EOF BOOLEAN;
528: l_num_of_Invoices NUMBER;

Line 530: l_GTA_Invoice_num Jmf_Gta_Trx_Headers_All.Gta_Trx_Number%TYPE;

526: l_values COLUMN_VALUES:=COLUMN_VALUES(NULL);
527: l_EOF BOOLEAN;
528: l_num_of_Invoices NUMBER;
529: l_num_of_lines NUMBER;
530: l_GTA_Invoice_num Jmf_Gta_Trx_Headers_All.Gta_Trx_Number%TYPE;
531: l_org_id NUMBER;
532: l_trx_rec JMF_GTA_TRX_UTIL.TRX_REC_TYPE;
533: l_trx_header_rec JMF_GTA_TRX_UTIL.TRX_header_rec_TYPE;
534: l_trx_line_rec JMF_GTA_TRX_UTIL.TRX_line_rec_TYPE;

Line 542: l_status Jmf_Gta_Trx_Headers_All.Status%TYPE;

538: l_fix_field VARCHAR2(100);
539: l_str VARCHAR2(100);
540: l_failed BOOLEAN;
541: l_line_num NUMBER;
542: l_status Jmf_Gta_Trx_Headers_All.Status%TYPE;
543: l_new_status Jmf_Gta_Trx_Headers_All.Status%TYPE;
544: l_Customer_Name Jmf_Gta_Trx_Headers_All.Bill_To_Customer_Name%TYPE;
545: l_TP_TAX_REG_NUMBER Jmf_Gta_Trx_Headers_All.TP_TAX_REGISTRATION_NUMBER%TYPE;
546: l_Invoice_Num Jmf_Gta_Trx_Headers_All.Gt_Invoice_Number%TYPE;

Line 543: l_new_status Jmf_Gta_Trx_Headers_All.Status%TYPE;

539: l_str VARCHAR2(100);
540: l_failed BOOLEAN;
541: l_line_num NUMBER;
542: l_status Jmf_Gta_Trx_Headers_All.Status%TYPE;
543: l_new_status Jmf_Gta_Trx_Headers_All.Status%TYPE;
544: l_Customer_Name Jmf_Gta_Trx_Headers_All.Bill_To_Customer_Name%TYPE;
545: l_TP_TAX_REG_NUMBER Jmf_Gta_Trx_Headers_All.TP_TAX_REGISTRATION_NUMBER%TYPE;
546: l_Invoice_Num Jmf_Gta_Trx_Headers_All.Gt_Invoice_Number%TYPE;
547: l_Invoice_date Jmf_Gta_Trx_Headers_All.Gt_Invoice_Date%TYPE;

Line 544: l_Customer_Name Jmf_Gta_Trx_Headers_All.Bill_To_Customer_Name%TYPE;

540: l_failed BOOLEAN;
541: l_line_num NUMBER;
542: l_status Jmf_Gta_Trx_Headers_All.Status%TYPE;
543: l_new_status Jmf_Gta_Trx_Headers_All.Status%TYPE;
544: l_Customer_Name Jmf_Gta_Trx_Headers_All.Bill_To_Customer_Name%TYPE;
545: l_TP_TAX_REG_NUMBER Jmf_Gta_Trx_Headers_All.TP_TAX_REGISTRATION_NUMBER%TYPE;
546: l_Invoice_Num Jmf_Gta_Trx_Headers_All.Gt_Invoice_Number%TYPE;
547: l_Invoice_date Jmf_Gta_Trx_Headers_All.Gt_Invoice_Date%TYPE;
548: l_Amount Jmf_Gta_Trx_Headers_All.Gt_Invoice_Net_Amount%TYPE;

Line 545: l_TP_TAX_REG_NUMBER Jmf_Gta_Trx_Headers_All.TP_TAX_REGISTRATION_NUMBER%TYPE;

541: l_line_num NUMBER;
542: l_status Jmf_Gta_Trx_Headers_All.Status%TYPE;
543: l_new_status Jmf_Gta_Trx_Headers_All.Status%TYPE;
544: l_Customer_Name Jmf_Gta_Trx_Headers_All.Bill_To_Customer_Name%TYPE;
545: l_TP_TAX_REG_NUMBER Jmf_Gta_Trx_Headers_All.TP_TAX_REGISTRATION_NUMBER%TYPE;
546: l_Invoice_Num Jmf_Gta_Trx_Headers_All.Gt_Invoice_Number%TYPE;
547: l_Invoice_date Jmf_Gta_Trx_Headers_All.Gt_Invoice_Date%TYPE;
548: l_Amount Jmf_Gta_Trx_Headers_All.Gt_Invoice_Net_Amount%TYPE;
549: l_conc_succ BOOLEAN;

Line 546: l_Invoice_Num Jmf_Gta_Trx_Headers_All.Gt_Invoice_Number%TYPE;

542: l_status Jmf_Gta_Trx_Headers_All.Status%TYPE;
543: l_new_status Jmf_Gta_Trx_Headers_All.Status%TYPE;
544: l_Customer_Name Jmf_Gta_Trx_Headers_All.Bill_To_Customer_Name%TYPE;
545: l_TP_TAX_REG_NUMBER Jmf_Gta_Trx_Headers_All.TP_TAX_REGISTRATION_NUMBER%TYPE;
546: l_Invoice_Num Jmf_Gta_Trx_Headers_All.Gt_Invoice_Number%TYPE;
547: l_Invoice_date Jmf_Gta_Trx_Headers_All.Gt_Invoice_Date%TYPE;
548: l_Amount Jmf_Gta_Trx_Headers_All.Gt_Invoice_Net_Amount%TYPE;
549: l_conc_succ BOOLEAN;
550: l_failed_XML XMLTYPE;

Line 547: l_Invoice_date Jmf_Gta_Trx_Headers_All.Gt_Invoice_Date%TYPE;

543: l_new_status Jmf_Gta_Trx_Headers_All.Status%TYPE;
544: l_Customer_Name Jmf_Gta_Trx_Headers_All.Bill_To_Customer_Name%TYPE;
545: l_TP_TAX_REG_NUMBER Jmf_Gta_Trx_Headers_All.TP_TAX_REGISTRATION_NUMBER%TYPE;
546: l_Invoice_Num Jmf_Gta_Trx_Headers_All.Gt_Invoice_Number%TYPE;
547: l_Invoice_date Jmf_Gta_Trx_Headers_All.Gt_Invoice_Date%TYPE;
548: l_Amount Jmf_Gta_Trx_Headers_All.Gt_Invoice_Net_Amount%TYPE;
549: l_conc_succ BOOLEAN;
550: l_failed_XML XMLTYPE;
551: l_succ_XML XMLTYPE;

Line 548: l_Amount Jmf_Gta_Trx_Headers_All.Gt_Invoice_Net_Amount%TYPE;

544: l_Customer_Name Jmf_Gta_Trx_Headers_All.Bill_To_Customer_Name%TYPE;
545: l_TP_TAX_REG_NUMBER Jmf_Gta_Trx_Headers_All.TP_TAX_REGISTRATION_NUMBER%TYPE;
546: l_Invoice_Num Jmf_Gta_Trx_Headers_All.Gt_Invoice_Number%TYPE;
547: l_Invoice_date Jmf_Gta_Trx_Headers_All.Gt_Invoice_Date%TYPE;
548: l_Amount Jmf_Gta_Trx_Headers_All.Gt_Invoice_Net_Amount%TYPE;
549: l_conc_succ BOOLEAN;
550: l_failed_XML XMLTYPE;
551: l_succ_XML XMLTYPE;
552: l_report_XML XMLTYPE;

Line 709: FROM JMF_GTA_TRX_HEADERS_ALL

705: , status
706: INTO l_header_id
707: , l_org_id
708: , l_status
709: FROM JMF_GTA_TRX_HEADERS_ALL
710: WHERE GTA_TRX_NUMBER=l_GTA_Invoice_num
711: AND SOURCE='AR'
712: AND latest_version_flag='Y';
713:

Line 736: DELETE JMF_GTA_TRX_HEADERS

732: END IF;*/
733: l_new_status:='COMPLETED';
734:
735: --clear the record imported before
736: DELETE JMF_GTA_TRX_HEADERS
737: WHERE GTA_TRX_NUMBER=l_GTA_Invoice_num
738: AND SOURCE='GT';
739:
740: DELETE JMF_GTA_TRX_LINES

Line 743: FROM JMF_GTA_TRX_HEADERS

739:
740: DELETE JMF_GTA_TRX_LINES
741: WHERE GTA_TRX_HEADER_ID IN
742: ( SELECT GTA_TRX_HEADER_ID
743: FROM JMF_GTA_TRX_HEADERS
744: WHERE GTA_TRX_NUMBER=l_GTA_Invoice_num
745: AND SOURCE='GT');
746:
747: --change the matched_flag to initiated status.

Line 753: UPDATE JMF_GTA_TRX_HEADERS

749: SET matched_flag='N'
750: WHERE GTA_TRX_HEADER_ID=l_header_id;
751:
752: --Requested by Donghai, for workbench judge whether upgrade version
753: UPDATE JMF_GTA_TRX_HEADERS
754: SET Status=l_new_status
755: , gt_invoice_date = l_Invoice_date
756: , gt_invoice_net_amount = l_values(10)
757: , gt_invoice_tax_amount = l_values(12)

Line 812: FROM JMF_GTA_TRX_HEADERS

808: , l_trx_header_rec.ra_trx_number
809: , l_trx_header_rec.Fp_Tax_Registration_Number
810: , l_trx_header_rec.Tp_Tax_Registration_Number
811: , l_trx_header_rec.Legal_Entity_Id
812: FROM JMF_GTA_TRX_HEADERS
813: WHERE GTA_TRX_HEADER_ID=l_header_id;
814:
815: --fill the data from GT
816: BEGIN

Line 856: SELECT jmf_gta_trx_headers_all_s.NEXTVAL

852:
853:
854:
855:
856: SELECT jmf_gta_trx_headers_all_s.NEXTVAL
857: INTO l_trx_header_rec.gta_trx_header_id
858: FROM dual;
859:
860: EXCEPTION

Line 1410: jmf_gta_trx_headers_all_pkg.query_row( p_header_id => p_invoice_header_id

1406:
1407: --put to the temporary output
1408: x_output(1):=fnd_message.get;
1409:
1410: jmf_gta_trx_headers_all_pkg.query_row( p_header_id => p_invoice_header_id
1411: , x_trx_header_rec => l_invoice
1412: );
1413:
1414: x_success:=check_header(l_invoice);

Line 1499: UPDATE jmf_gta_trx_headers

1495: x_output(2):=l_header_output;
1496:
1497: --change GTA status
1498: --fill request_id etc. to P_INVOICE;
1499: UPDATE jmf_gta_trx_headers
1500: SET status='GENERATED'
1501: , gta_batch_number =p_batch_number
1502: , export_request_id =fnd_global.CONC_REQUEST_ID
1503: , REQUEST_ID =fnd_global.CONC_REQUEST_ID

Line 1526: UPDATE jmf_gta_trx_headers

1522: i:=x_output.NEXT(i);
1523: END LOOP;
1524: END IF ;
1525:
1526: UPDATE jmf_gta_trx_headers
1527: SET export_request_id =fnd_global.CONC_REQUEST_ID
1528: , REQUEST_ID =fnd_global.CONC_REQUEST_ID
1529: , PROGRAM_APPLICATION_ID=fnd_global.RESP_APPL_ID
1530: , PROGRAM_ID =fnd_global.CONC_PROGRAM_ID

Line 1613: l_header_rec_cur Jmf_Gta_Trx_Headers_all%ROWTYPE;

1609: , p_draft_dup_cur IN crmemo_dup_cur_TYPE DEFAULT NULL
1610: )
1611: IS
1612: l_procedure_name VARCHAR2(30):='export_Invoices';
1613: l_header_rec_cur Jmf_Gta_Trx_Headers_all%ROWTYPE;
1614: l_succ_output t_invoice_export_output:=t_invoice_export_output();
1615: l_exceed_output t_invoice_export_output:=t_invoice_export_output();
1616: l_taxpayid_err_out t_invoice_export_output:=t_invoice_export_output();
1617: l_creddit_memo_err t_invoice_export_output:=t_invoice_export_output();

Line 1623: l_gta_trx_header_id jmf_gta_trx_headers_all.gta_trx_header_id%TYPE;

1619:
1620: l_trx_export_success PLS_INTEGER;
1621: l_error_msg VARCHAR2(5000);
1622: l_conc_succ BOOLEAN;
1623: l_gta_trx_header_id jmf_gta_trx_headers_all.gta_trx_header_id%TYPE;
1624: i INTEGER;
1625: l_str VARCHAR2(1000); --Jun-22, 2006, jogen bug 5335265
1626: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
1627: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

Line 1743: jmf_gta_trx_headers_all_pkg.query_row( p_header_id => l_gta_trx_header_id

1739: * 'Notification Number for Issued VAT Credit memo+16-digit Notification number'
1740: * if check fails, message 'JMF_GTA_CRMEMO_MISSING_PREFIX' is wroten to output
1741: * file.
1742: */
1743: jmf_gta_trx_headers_all_pkg.query_row( p_header_id => l_gta_trx_header_id
1744: , x_trx_header_rec => p_GTA_trx_header
1745: );
1746:
1747: SELECT DISTINCT RCTT.type

Line 1749: FROM JMF_GTA_TRX_HEADERS_ALL JGTH

1745: );
1746:
1747: SELECT DISTINCT RCTT.type
1748: INTO lv_trx_type
1749: FROM JMF_GTA_TRX_HEADERS_ALL JGTH
1750: , RA_CUST_TRX_TYPES_ALL RCTT
1751: , RA_CUSTOMER_TRX_ALL RCT
1752: WHERE RCTT.cust_trx_type_id = RCT.cust_trx_type_id
1753: AND JGTH.source = 'AR'

Line 2194: FROM jmf_gta_trx_headers

2190: --Jogen Jun-12 2006, bug5351578
2191:
2192: SELECT COUNT(*)
2193: INTO l_rows_same_batch
2194: FROM jmf_gta_trx_headers
2195: WHERE gta_batch_number=x_batch_number;
2196:
2197: IF l_rows_same_batch > 0
2198: THEN

Line 2311: l_batch_number Jmf_Gta_Trx_Headers_All.Gta_Batch_Number%TYPE:=p_batch_number;

2307: -------------------------------------------------------------------------------
2308:
2309: l_error_msg VARCHAR2(1000);
2310:
2311: l_batch_number Jmf_Gta_Trx_Headers_All.Gta_Batch_Number%TYPE:=p_batch_number;
2312: l_batch_number_ok BOOLEAN;
2313: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
2314: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
2315: l_invoice_type_check VARCHAR2(1); --added for invoice_type condition by Subba.

Line 2381: FROM JMF_GTA_TRX_HEADERS h

2377: IF P_Invoice_Type_ID <>'A' THEN --if user selects a particular invoice_type
2378: OPEN l_cur_header FOR
2379: SELECT
2380: h.*
2381: FROM JMF_GTA_TRX_HEADERS h
2382: , ra_customer_trx_all ar
2383: , Ra_Cust_Trx_Types_all ctt
2384: , RA_CUST_TRX_LINE_GL_DIST_all gd
2385: , ra_batches_all b

Line 2426: FROM JMF_GTA_TRX_HEADERS_ALL JGTHA

2422: SELECT JGTHA.ra_trx_id
2423: , JGTHA.description
2424: , JGTHA.org_id
2425: , JGTHA.gta_trx_number
2426: FROM JMF_GTA_TRX_HEADERS_ALL JGTHA
2427: WHERE Get_Trx_Class(JGTHA.org_id, JGTHA.ra_trx_id) = 'CM'
2428: AND JGTHA.status IN ('GENERATED', 'COMPLETED')
2429:
2430: AND JGTHA.description IN /*( SELECT h.description

Line 2431: FROM JMF_GTA_TRX_HEADERS h

2427: WHERE Get_Trx_Class(JGTHA.org_id, JGTHA.ra_trx_id) = 'CM'
2428: AND JGTHA.status IN ('GENERATED', 'COMPLETED')
2429:
2430: AND JGTHA.description IN /*( SELECT h.description
2431: FROM JMF_GTA_TRX_HEADERS h
2432: , ra_customer_trx_all ar
2433: , Ra_Cust_Trx_Types_all ctt
2434: , RA_CUST_TRX_LINE_GL_DIST_all gd
2435: , ra_batches_all b

Line 2468: FROM JMF_GTA_TRX_HEADERS JGTH

2464: HAVING COUNT(h.description) > 1)*/
2465:
2466: ( SELECT DISTINCT description
2467: FROM (SELECT description
2468: FROM JMF_GTA_TRX_HEADERS JGTH
2469: WHERE JGTH.status IN ('GENERATED', 'COMPLETED')
2470: INTERSECT
2471: SELECT h.description
2472: FROM JMF_GTA_TRX_HEADERS h

Line 2472: FROM JMF_GTA_TRX_HEADERS h

2468: FROM JMF_GTA_TRX_HEADERS JGTH
2469: WHERE JGTH.status IN ('GENERATED', 'COMPLETED')
2470: INTERSECT
2471: SELECT h.description
2472: FROM JMF_GTA_TRX_HEADERS h
2473: , ra_customer_trx_all ar
2474: , Ra_Cust_Trx_Types_all ctt
2475: , RA_CUST_TRX_LINE_GL_DIST_all gd
2476: , ra_batches_all b

Line 2524: FROM JMF_GTA_TRX_HEADERS_ALL JGTHA

2520: SELECT JGTHA.ra_trx_id
2521: , JGTHA.description
2522: , JGTHA.org_id
2523: , JGTHA.gta_trx_number
2524: FROM JMF_GTA_TRX_HEADERS_ALL JGTHA
2525: , ra_customer_trx_all ar
2526: , Ra_Cust_Trx_Types_all ctt
2527: , RA_CUST_TRX_LINE_GL_DIST_all gd
2528: , ra_batches_all b

Line 2571: FROM JMF_GTA_TRX_HEADERS h

2567: AND JGTHA.SOURCE = 'AR'
2568: AND JGTHA.invoice_type = P_Invoice_Type_ID
2569:
2570: AND JGTHA.description IN /*( SELECT h.description
2571: FROM JMF_GTA_TRX_HEADERS h
2572: , ra_customer_trx_all ar
2573: , Ra_Cust_Trx_Types_all ctt
2574: , RA_CUST_TRX_LINE_GL_DIST_all gd
2575: , ra_batches_all b

Line 2608: FROM JMF_GTA_TRX_HEADERS JGTH

2604: HAVING COUNT(h.description) > 1)*/
2605:
2606: ( SELECT DISTINCT description
2607: FROM (SELECT description
2608: FROM JMF_GTA_TRX_HEADERS JGTH
2609: WHERE JGTH.status IN ('GENERATED', 'COMPLETED')
2610: INTERSECT
2611: SELECT h.description
2612: FROM JMF_GTA_TRX_HEADERS h

Line 2612: FROM JMF_GTA_TRX_HEADERS h

2608: FROM JMF_GTA_TRX_HEADERS JGTH
2609: WHERE JGTH.status IN ('GENERATED', 'COMPLETED')
2610: INTERSECT
2611: SELECT h.description
2612: FROM JMF_GTA_TRX_HEADERS h
2613: , ra_customer_trx_all ar
2614: , Ra_Cust_Trx_Types_all ctt
2615: , RA_CUST_TRX_LINE_GL_DIST_all gd
2616: , ra_batches_all b

Line 2668: FROM JMF_GTA_TRX_HEADERS h

2664:
2665: /* OPEN l_cur_header FOR
2666: SELECT
2667: h.*
2668: FROM JMF_GTA_TRX_HEADERS h
2669: , ra_customer_trx_all ar
2670: , Ra_Cust_Trx_Types_all ctt
2671: , RA_CUST_TRX_LINE_GL_DIST_all gd
2672: , ra_batches_all b

Line 2713: FROM JMF_GTA_TRX_HEADERS

2709:
2710:
2711: OPEN l_cur_header FOR
2712: SELECT *
2713: FROM JMF_GTA_TRX_HEADERS
2714: WHERE Gta_Batch_Number=P_Batch_ID
2715: AND status='GENERATED';
2716:
2717: export_Invoices(l_cur_header,P_Batch_ID, NULL, NULL);

Line 2787: l_batch_number Jmf_Gta_Trx_Headers_All.Gta_Batch_Number%TYPE:=P_Batch_ID;

2783: l_cur_draft_dup crmemo_dup_cur_TYPE;--get draft crmemo with duplicate description
2784: -------------------------------------------------------------------------------
2785: --add by Lv Xiao for bug#7626503 on 11-Dec-2008, end
2786:
2787: l_batch_number Jmf_Gta_Trx_Headers_All.Gta_Batch_Number%TYPE:=P_Batch_ID;
2788: l_batch_number_ok BOOLEAN;
2789: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
2790: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
2791: BEGIN

Line 2815: FROM JMF_GTA_TRX_HEADERS

2811:
2812:
2813: OPEN l_cur_header FOR
2814: SELECT *
2815: FROM JMF_GTA_TRX_HEADERS
2816: WHERE Generator_Id=p_generator_ID
2817: AND status='DRAFT';
2818:
2819: --add by Lv Xiao for bug#7626503 on 11-Dec-2008, begin

Line 2833: FROM JMF_GTA_TRX_HEADERS_ALL JGTHA

2829: SELECT JGTHA.ra_trx_id
2830: , JGTHA.description
2831: , JGTHA.org_id
2832: , JGTHA.gta_trx_number
2833: FROM JMF_GTA_TRX_HEADERS_ALL JGTHA
2834: WHERE Get_Trx_Class(JGTHA.org_id, JGTHA.ra_trx_id) = 'CM'
2835: AND JGTHA.Invoice_Type<>'2'--yao zhang add for bug 7673309
2836: AND JGTHA.source='AR'--yao zhang add for bug7673309
2837: AND JGTHA.status IN ('GENERATED', 'COMPLETED')

Line 2844: FROM JMF_GTA_TRX_HEADERS_ALL JGTH

2840: --modified by Lv Xiao for bug#7644803 on 16-Dec-08, begin
2841: -------------------------------------------------------------------
2842: /* AND JGTHA.description IN ( SELECT DISTINCT description
2843: FROM (SELECT description
2844: FROM JMF_GTA_TRX_HEADERS_ALL JGTH
2845: WHERE JGTH.status IN ('GENERATED', 'COMPLETED')
2846: INTERSECT
2847: SELECT description
2848: FROM JMF_GTA_TRX_HEADERS_ALL

Line 2848: FROM JMF_GTA_TRX_HEADERS_ALL

2844: FROM JMF_GTA_TRX_HEADERS_ALL JGTH
2845: WHERE JGTH.status IN ('GENERATED', 'COMPLETED')
2846: INTERSECT
2847: SELECT description
2848: FROM JMF_GTA_TRX_HEADERS_ALL
2849: WHERE Generator_Id=p_generator_ID
2850: AND status='DRAFT') )*/
2851:
2852:

Line 2854: FROM JMF_GTA_TRX_HEADERS JGTH

2850: AND status='DRAFT') )*/
2851:
2852:
2853: AND JGTHA.description IN ( SELECT description
2854: FROM JMF_GTA_TRX_HEADERS JGTH
2855: WHERE (( status = 'DRAFT'
2856: AND generator_id = p_generator_ID )
2857: OR status IN ('GENERATED', 'COMPLETED'))
2858: AND Invoice_Type<>'2'--yao zhang add for bug 7673309

Line 2869: FROM JMF_GTA_TRX_HEADERS_ALL JGTHA

2865: SELECT JGTHA.ra_trx_id
2866: , JGTHA.description
2867: , JGTHA.org_id
2868: , JGTHA.gta_trx_number
2869: FROM JMF_GTA_TRX_HEADERS_ALL JGTHA
2870: WHERE Get_Trx_Class(JGTHA.org_id, JGTHA.ra_trx_id) = 'CM'
2871: AND JGTHA.Invoice_Type<>'2'--Yao Zhang add for bug 7673309
2872: AND JGTHA.source='AR'--Yao Zhang add for bug 7673309
2873: AND JGTHA.status = 'DRAFT'

Line 2878: FROM JMF_GTA_TRX_HEADERS_ALL JGTH

2874: AND JGTHA.generator_id = p_generator_ID
2875: AND JGTHA.org_id = p_org_id
2876: /* AND JGTHA.description IN ( SELECT DISTINCT description
2877: FROM (SELECT description
2878: FROM JMF_GTA_TRX_HEADERS_ALL JGTH
2879: WHERE JGTH.status IN ('GENERATED', 'COMPLETED')
2880: INTERSECT
2881: SELECT description
2882: FROM JMF_GTA_TRX_HEADERS_ALL

Line 2882: FROM JMF_GTA_TRX_HEADERS_ALL

2878: FROM JMF_GTA_TRX_HEADERS_ALL JGTH
2879: WHERE JGTH.status IN ('GENERATED', 'COMPLETED')
2880: INTERSECT
2881: SELECT description
2882: FROM JMF_GTA_TRX_HEADERS_ALL
2883: WHERE Generator_Id=p_generator_ID
2884: AND status='DRAFT') ) ;*/
2885:
2886:

Line 2888: FROM JMF_GTA_TRX_HEADERS JGTH

2884: AND status='DRAFT') ) ;*/
2885:
2886:
2887: AND JGTHA.description IN ( SELECT description
2888: FROM JMF_GTA_TRX_HEADERS JGTH
2889: WHERE (( status = 'DRAFT'
2890: AND generator_id = p_generator_ID )
2891: OR status IN ('GENERATED', 'COMPLETED'))
2892: AND Invoice_Type<>'2'--Yao Zhang add for bug7673309

Line 2985: , JMF_GTA_TRX_HEADERS_ALL JGTH

2981: SELECT DISTINCT RCTT.type
2982: INTO lv_class_type
2983: FROM RA_CUST_TRX_TYPES_ALL RCTT
2984: , RA_CUSTOMER_TRX_ALL RCT
2985: , JMF_GTA_TRX_HEADERS_ALL JGTH
2986: WHERE RCTT.cust_trx_type_id = RCT.cust_trx_type_id
2987: AND JGTH.source = 'AR'
2988: AND RCTT.org_id = p_GTA_org_id
2989: AND RCT.customer_trx_id = p_GTA_trx_id