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.JAI_AR_RCTLA_TRIGGER_PKG dependencies on RA_CUSTOMER_TRX_ALL

Line 132: From RA_CUST_TRX_TYPES_ALL a, RA_CUSTOMER_TRX_ALL b

128: v_trans_type Varchar2(30);
129:
130: /*Cursor transaction_type_cur IS
131: Select a.type
132: From RA_CUST_TRX_TYPES_ALL a, RA_CUSTOMER_TRX_ALL b
133: Where a.cust_trx_type_id = b.cust_trx_type_id
134: And b.customer_trx_id = v_customer_trx_id
135: And NVL(a.org_id,0) = NVL(pr_old.org_id,0);
136: */

Line 147: FROM RA_CUSTOMER_TRX_ALL

143: Where cust_trx_type_id
144: in
145: (
146: SELECT cust_trx_type_id
147: FROM RA_CUSTOMER_TRX_ALL
148: WHERE CUSTOMER_TRX_ID = v_customer_trx_id
149: AND org_id = pr_old.ORG_ID /* Modified by Ramananda for removal of SQL LITERALs */
150: --AND org_id = NVL(pr_old.ORG_ID,0)
151: )

Line 349: From RA_CUST_TRX_TYPES_ALL a, RA_CUSTOMER_TRX_ALL b

345:
346:
347: Cursor transaction_type_cur IS
348: Select a.type
349: From RA_CUST_TRX_TYPES_ALL a, RA_CUSTOMER_TRX_ALL b
350: Where a.cust_trx_type_id = b.cust_trx_type_id
351: And b.customer_trx_id = v_header_id
352: And NVL(a.org_id,0) = NVL(pr_new.org_id,0);
353:

Line 383: FROM RA_CUSTOMER_TRX_ALL

379:
380:
381: Cursor header_info_cur IS
382: SELECT created_from, set_of_books_id, invoice_currency_code, exchange_rate_type, nvl(exchange_date,trx_date), exchange_rate
383: FROM RA_CUSTOMER_TRX_ALL
384: WHERE customer_trx_id = v_header_id;
385:
386: Cursor localization_header_info_cur IS
387: SELECT organization_id

Line 414: Manual Credit memo with reference to invoice has ra_customer_trx_all.created_from as ARXTWCMI

410: The reason this was happening is because this trigger has code to copy the
411: taxes from the invoice against which the credit memo is applied.
412:
413: Added code to return control when a manual credit memo without reference is created.
414: Manual Credit memo with reference to invoice has ra_customer_trx_all.created_from as ARXTWCMI
415: Manual Credit memo without reference to invoice has ra_customer_trx_all.created_from as ARXTWMAI
416: 3. 08-Jun-2005 This Object is Modified to refer to New DB Entity names in place of Old
417: DB Entity as required for CASE COMPLAINCE. Version 116.1
418:

Line 415: Manual Credit memo without reference to invoice has ra_customer_trx_all.created_from as ARXTWMAI

411: taxes from the invoice against which the credit memo is applied.
412:
413: Added code to return control when a manual credit memo without reference is created.
414: Manual Credit memo with reference to invoice has ra_customer_trx_all.created_from as ARXTWCMI
415: Manual Credit memo without reference to invoice has ra_customer_trx_all.created_from as ARXTWMAI
416: 3. 08-Jun-2005 This Object is Modified to refer to New DB Entity names in place of Old
417: DB Entity as required for CASE COMPLAINCE. Version 116.1
418:
419: 4. 10-Jun-2005 File Version: 116.2

Line 751: FROM RA_CUSTOMER_TRX_ALL

747: SELECT bill_to_customer_id,
748: bill_to_site_use_id,
749: trx_number,
750: batch_source_id
751: FROM RA_CUSTOMER_TRX_ALL
752: WHERE customer_trx_id = pr_new.customer_trx_id;
753: CURSOR GET_SITE(P_TRX_NUMBER VARCHAR2) IS
754: SELECT customer_site
755: FROM JAI_AR_SUP_HDRS_ALL

Line 762: FROM ra_customer_trx_all

758:
759: -------------- cursor for st forms tracking -------------
760: CURSOR GET_EXCHANGE_RATE IS
761: SELECT exchange_rate
762: FROM ra_customer_trx_all
763: WHERE customer_trx_id = pr_new.customer_trx_id;
764: CURSOR CREATED_FROM_CUR IS
765: SELECT created_from, trx_number, batch_source_id, set_of_books_id, primary_salesrep_id,
766: invoice_currency_code, exchange_rate_type, exchange_date, exchange_rate

Line 767: FROM ra_customer_trx_all

763: WHERE customer_trx_id = pr_new.customer_trx_id;
764: CURSOR CREATED_FROM_CUR IS
765: SELECT created_from, trx_number, batch_source_id, set_of_books_id, primary_salesrep_id,
766: invoice_currency_code, exchange_rate_type, exchange_date, exchange_rate
767: FROM ra_customer_trx_all
768: WHERE customer_trx_id = v_header_id;
769:
770: CURSOR SO_PICKING_HDR_INFO IS
771: SELECT A.organization_id, A.location_id

Line 840: RA_CUSTOMER_TRX_ALL C

836: SELECT A.organization_id,
837: A.Location_id
838: FROM JAI_AR_TRXS A,
839: JAI_AR_SUP_HDRS_ALL B,
840: RA_CUSTOMER_TRX_ALL C
841: WHERE pr_new.customer_trx_id = c.customer_trx_id
842: AND c.trx_number = TO_CHAR(B.SUPPLEMENTARY_NUM)
843: AND B.customer_trx_id = A.customer_trx_id;
844:

Line 877: ra_customer_trx_all b,

873: (NVL(A.excise_diff_amt,0)+NVL(A.other_diff_amt,0)) TAX_AMT,
874: NVL(A.excise_diff_amt,0) excise_diff,
875: A.new_assessable_value
876: FROM JAI_AR_SUP_LINES A,
877: ra_customer_trx_all b,
878: ra_cust_trx_types_all c
879: WHERE B.CUST_TRX_TYPE_ID = C.CUST_TRX_TYPE_ID
880: AND A.SUP_INV_TYPE = DECODE(C.TYPE,'DM','DB','CM','CR','INV','SI')
881: AND A.customer_trx_line_id = TO_NUMBER(pr_new.interface_line_attribute3)

Line 890: ra_customer_trx_all c,

886: NVL(A.excise_diff_amt,0) excise_diff,
887: A.new_assessable_value
888: FROM JAI_AR_SUP_LINES A,
889: JAI_AR_SUP_HDRS_ALL b,
890: ra_customer_trx_all c,
891: ra_cust_trx_types_all e
892: WHERE pr_new.customer_trx_id = c.customer_trx_id
893: AND c.trx_number = TO_CHAR( b.SUPPLEMENTARY_NUM)
894: AND B.customer_trx_id = A.customer_trx_id

Line 909: ra_customer_trx_all c,

905: CURSOR SUPPLEMENT_LINES_INFO_Tax_catg IS
906: SELECT A.tax_category_id
907: FROM JAI_AR_SUP_LINES A,
908: JAI_AR_SUP_HDRS_ALL b,
909: ra_customer_trx_all c,
910: ra_cust_trx_types_all D
911: WHERE pr_new.customer_trx_id = c.customer_trx_id
912: AND c.trx_number =TO_CHAR( b.SUPPLEMENTARY_NUM)
913: AND B.customer_trx_id = A.customer_trx_id

Line 976: ra_customer_trx_all C,

972: t.tax_type,
973: t.stform_type
974: FROM JAI_AR_SUP_TAXES A,
975: JAI_AR_SUP_LINES b,
976: ra_customer_trx_all C,
977: ra_cust_trx_types_all D,
978: JAI_CMN_TAXES_ALL t
979: WHERE A.link_to_cust_trx_line_id = b.customer_trx_line_id
980: AND A.sup_inv_type = b.sup_inv_type

Line 1001: ra_customer_trx_all D,

997: t.stform_type
998: FROM JAI_AR_SUP_TAXES A,
999: JAI_AR_SUP_LINES b,
1000: JAI_AR_SUP_HDRS_ALL c,
1001: ra_customer_trx_all D,
1002: ra_cust_trx_types_all e,
1003: JAI_CMN_TAXES_ALL t
1004: WHERE pr_new.customer_trx_id = D.customer_trx_id
1005: AND D.trx_number = TO_CHAR(c.SUPPLEMENTARY_NUM)

Line 1050: RA_CUSTOMER_TRX_ALL C,

1046: CURSOR SUPPLEMENT_LINES_CHECK_CNSLDT IS
1047: SELECT 1
1048: FROM JAI_AR_SUP_LINES A,
1049: JAI_AR_SUP_HDRS_ALL B,
1050: RA_CUSTOMER_TRX_ALL C,
1051: RA_CUST_TRX_TYPES_ALL D
1052: WHERE pr_new.CUSTOMER_TRX_ID = C.customer_trx_id
1053: AND c.cust_trx_type_id = D.cust_trx_type_id
1054: AND c.trx_number = TO_CHAR(b.SUPPLEMENTARY_NUM)

Line 1077: RA_CUSTOMER_TRX_ALL C,

1073: CURSOR SUPPLEMENT_TAX_LINES_CHECK_CNS IS
1074: SELECT 1
1075: FROM JAI_AR_SUP_LINES A,
1076: JAI_AR_SUP_HDRS_ALL B,
1077: RA_CUSTOMER_TRX_ALL C,
1078: RA_CUST_TRX_TYPES_ALL D,
1079: JAI_AR_SUP_TAXES E
1080: WHERE pr_new.CUSTOMER_TRX_ID = C.customer_trx_id
1081: AND c.cust_trx_type_id = D.cust_trx_type_id

Line 1091: FROM ra_customer_trx_all

1087: AND A.sup_inv_type = e.sup_inv_type;
1088:
1089: CURSOR complete_flag_cur IS
1090: SELECT complete_flag
1091: FROM ra_customer_trx_all
1092: WHERE customer_trx_id = v_header_id;
1093: v_trans_type VARCHAR2(30);
1094:
1095: CURSOR transaction_type_cur IS

Line 1097: FROM RA_CUST_TRX_TYPES_ALL A, RA_CUSTOMER_TRX_ALL b

1093: v_trans_type VARCHAR2(30);
1094:
1095: CURSOR transaction_type_cur IS
1096: SELECT A.TYPE
1097: FROM RA_CUST_TRX_TYPES_ALL A, RA_CUSTOMER_TRX_ALL b
1098: WHERE A.cust_trx_type_id = b.cust_trx_type_id
1099: AND b.customer_trx_id = v_header_id
1100: AND NVL(A.org_id,0) = NVL(pr_new.org_id,0);
1101: /* Code Added For Service Module */

Line 1324: FROM ra_customer_trx_all

1320: v_part_i_register_id NUMBER ;
1321:
1322: CURSOR site_cur IS
1323: SELECT SHIP_TO_CUSTOMER_ID,SHIP_TO_SITE_USE_ID
1324: FROM ra_customer_trx_all
1325: WHERE customer_trx_id = pr_new.customer_trx_id
1326: AND org_id = pr_new.org_id;
1327:
1328:

Line 1414: FROM RA_CUSTOMER_TRX_ALL

1410: FUNCTION get_legal_entity_id RETURN NUMBER IS
1411:
1412: CURSOR cur_legal_entity_id IS
1413: SELECT legal_entity_id
1414: FROM RA_CUSTOMER_TRX_ALL
1415: WHERE customer_trx_id = pr_new.customer_trx_id ;
1416:
1417: ln_legal_entity_id NUMBER ;
1418:

Line 2009: from ra_customer_trx_all

2005: exchange_rate ,
2006: created_from ,
2007: nvl(bill_to_customer_id,ship_to_customer_id) customer_id , -- Date 26-feb-2006 added by sacsethi for bug 5631784
2008: trx_date
2009: from ra_customer_trx_all
2010: where customer_trx_id = pr_new.customer_trx_id;
2011:
2012: CURSOR JA_SO_LINES_INFO IS
2013: SELECT tax_category_id ,

Line 4561: FROM ra_customer_trx_all

4557: CURSOR CREATED_FROM_CUR IS
4558: SELECT created_from, trx_number, batch_source_id, set_of_books_id, primary_salesrep_id,
4559: invoice_currency_code, exchange_rate_type, exchange_date, exchange_rate,
4560: legal_entity_id /* rallamse bug#4448789 */
4561: FROM ra_customer_trx_all
4562: WHERE customer_trx_id = v_header_id;
4563:
4564:
4565: -- following cursor definition modified by sriram - bug # 2755890 - 18/01/2003

Line 4640: FROM RA_CUST_TRX_TYPES_ALL A, RA_CUSTOMER_TRX_ALL b

4636:
4637: v_trans_type VARCHAR2(30);
4638: CURSOR transaction_type_cur IS
4639: SELECT A.TYPE
4640: FROM RA_CUST_TRX_TYPES_ALL A, RA_CUSTOMER_TRX_ALL b
4641: WHERE A.cust_trx_type_id = b.cust_trx_type_id
4642: AND b.customer_trx_id = v_header_id
4643: AND NVL(A.org_id,0) = NVL(pr_new.org_id,0);
4644:

Line 4676: ra_customer_trx_all rct,

4672: IS
4673: SELECT
4674: ott.transaction_type_id
4675: FROM
4676: ra_customer_trx_all rct,
4677: oe_transaction_types_tl ott
4678: WHERE
4679: rct.customer_trx_id = nvl(pr_new.previous_customer_trx_id ,pr_new.customer_trx_id) --added nvl for bug#10156485
4680: /* bug 4926865. Added by Lakshmi Gopalsami

Line 4744: from ra_customer_trx_all

4740: exchange_rate ,
4741: created_from ,
4742: nvl(bill_to_customer_id,ship_to_customer_id) customer_id ,
4743: trx_date
4744: from ra_customer_trx_all
4745: where customer_trx_id = pr_new.customer_trx_id;
4746:
4747: CURSOR SO_RMA_LINES_INFO IS
4748: --added unit_code,line_amount

Line 5407: The legal_entity_id is derived from CREATED_FROM_CUR cursor based on ra_customer_trx_all.

5403: 12. 10-Jun-2005 rallamse bug#4448789 116.3
5404: Added legal_entity_id for table JAI_AR_TRXS in insert statement
5405:
5406: 13. 26-07-2005 rallamse bug#4510143 120.2
5407: The legal_entity_id is derived from CREATED_FROM_CUR cursor based on ra_customer_trx_all.
5408:
5409: 14. 24-Aug-2005 Ramananda for bug #4567935 (115 bug 4404898, 4395450). File version 120.2
5410: Issue:-
5411: 1. The following type of taxes should not be inserted into JAI_AR_TRX_LINES when Order type is BOND register:-

Line 6000: FROM ra_customer_trx_all

5996: exchange_rate_type,
5997: exchange_date,
5998: exchange_rate,
5999: legal_entity_id
6000: FROM ra_customer_trx_all
6001: WHERE customer_trx_id = v_header_id;
6002:
6003: CURSOR DUPLICATE_HDR_CUR IS
6004: SELECT 1

Line 6018: FROM RA_CUST_TRX_TYPES_ALL A, RA_CUSTOMER_TRX_ALL b

6014: v_trans_type VARCHAR2(30);
6015:
6016: CURSOR transaction_type_cur IS
6017: SELECT A.TYPE
6018: FROM RA_CUST_TRX_TYPES_ALL A, RA_CUSTOMER_TRX_ALL b
6019: WHERE A.cust_trx_type_id = b.cust_trx_type_id
6020: AND b.customer_trx_id = v_header_id
6021: AND NVL(A.org_id,0) = NVL(pr_new.org_id,0);
6022:

Line 6268: cursor c_gl_dist_date ( cp_customer_trx_id ra_customer_trx_all.customer_trx_id%type)

6264: v_service_type VARCHAR2(30); -- added by csahoo for bug#5879769
6265: v_num_check Number; /*Added by nprashar for TCS*/
6266: -- lv_enable_gst_flag VARCHAR2(3);--Added by Xiao Lv for bug 10091373
6267:
6268: cursor c_gl_dist_date ( cp_customer_trx_id ra_customer_trx_all.customer_trx_id%type)
6269: is
6270: select gl_date
6271: from ra_cust_trx_line_gl_dist_all
6272: where customer_trx_id = cp_customer_trx_id

Line 6322: FROM RA_CUSTOMER_TRX_ALL A

6318: Cursor bind_cur IS /*Bug 8371741 - Modified to use Bill to Account*/
6319: /* SELECT A.org_id, Commented by nprashar for bug # 9489145
6320: A.bill_to_customer_id,
6321: NVL(A.bill_to_site_use_id,0)
6322: FROM RA_CUSTOMER_TRX_ALL A
6323: WHERE customer_trx_id = v_header_id; */
6324:
6325: SELECT A.org_id, /*Added by nprashar for bug # 9489145*/
6326: A.ship_to_customer_id,

Line 6330: FROM RA_CUSTOMER_TRX_ALL A

6326: A.ship_to_customer_id,
6327: NVL(A.ship_to_site_use_id,0),
6328: A.bill_to_customer_id,
6329: NVL(A.bill_to_site_use_id,0)
6330: FROM RA_CUSTOMER_TRX_ALL A
6331: WHERE customer_trx_id = v_header_id;
6332:
6333:
6334: Cursor header_info_cur IS

Line 6340: FROM RA_CUSTOMER_TRX_ALL

6336: invoice_currency_code,
6337: exchange_rate_type,
6338: exchange_date,
6339: exchange_rate, trx_date
6340: FROM RA_CUSTOMER_TRX_ALL
6341: WHERE customer_trx_id = v_header_id;
6342:
6343: Cursor address_cur(p_ship_to_site_use_id IN Number) IS
6344: SELECT cust_acct_site_id address_id

Line 6379: FROM JAI_AR_TRXS A, RA_CUSTOMER_TRX_ALL B

6375: FROM JAI_AR_TRX_APPS_RELS_T ;/*altered by rchandan for bug#4479131*/
6376:
6377: CURSOR organization_cur IS
6378: SELECT A.organization_id, location_id--Added by Xiao Lv for bug 10091373
6379: FROM JAI_AR_TRXS A, RA_CUSTOMER_TRX_ALL B
6380: WHERE A.trx_number = B.recurred_from_trx_number AND B.customer_trx_id = v_header_id;
6381:
6382: CURSOR CREATED_FROM_CUR IS
6383: SELECT created_from , trx_date

Line 6384: FROM ra_customer_trx_all

6380: WHERE A.trx_number = B.recurred_from_trx_number AND B.customer_trx_id = v_header_id;
6381:
6382: CURSOR CREATED_FROM_CUR IS
6383: SELECT created_from , trx_date
6384: FROM ra_customer_trx_all
6385: WHERE customer_trx_id = v_header_id;
6386:
6387: ld_trx_date ra_customer_trx_all.trx_Date%type;
6388:

Line 6387: ld_trx_date ra_customer_trx_all.trx_Date%type;

6383: SELECT created_from , trx_date
6384: FROM ra_customer_trx_all
6385: WHERE customer_trx_id = v_header_id;
6386:
6387: ld_trx_date ra_customer_trx_all.trx_Date%type;
6388:
6389: CURSOR ONCE_COMPLETE_FLAG_CUR IS
6390: SELECT once_completed_flag
6391: FROM JAI_AR_TRXS

Line 6396: FROM RA_CUSTOMER_TRX_ALL

6392: WHERE customer_trx_id = v_header_id;
6393:
6394: CURSOR ROW_ID_CUR IS
6395: SELECT rowid
6396: FROM RA_CUSTOMER_TRX_ALL
6397: WHERE customer_trx_id = v_header_id;
6398:
6399: CURSOR old_line_amount_cur IS
6400: SELECT line_amount

Line 6413: From RA_CUST_TRX_TYPES_ALL a, RA_CUSTOMER_TRX_ALL b

6409:
6410:
6411: Cursor transaction_type_cur IS
6412: Select a.type
6413: From RA_CUST_TRX_TYPES_ALL a, RA_CUSTOMER_TRX_ALL b
6414: Where a.cust_trx_type_id = b.cust_trx_type_id
6415: And b.customer_trx_id = v_header_id
6416: And NVL(a.org_id,0) = NVL(pr_new.org_id,0);
6417:

Line 7048: FROM RA_CUSTOMER_TRX_ALL A

7044: /* --Ramananda for File.Sql.35 */
7045:
7046: Cursor bind_cur IS
7047: SELECT A.org_id,A.bill_to_customer_id,NVL(A.bill_to_site_use_id,0) /*Bug 8371741 - Modified to use Bill To Account details*/
7048: FROM RA_CUSTOMER_TRX_ALL A
7049: WHERE customer_trx_id = v_header_id;
7050:
7051: Cursor header_info_cur IS
7052: SELECT set_of_books_id , invoice_currency_code,

Line 7055: FROM RA_CUSTOMER_TRX_ALL

7051: Cursor header_info_cur IS
7052: SELECT set_of_books_id , invoice_currency_code,
7053: exchange_rate_type, exchange_date,
7054: exchange_rate , trx_date
7055: FROM RA_CUSTOMER_TRX_ALL
7056: WHERE customer_trx_id = v_header_id;
7057:
7058: CURSOR excise_cal_cur IS
7059: select A.tax_id, A.tax_rate, A.tax_amount tax_amt,b.tax_type t_type

Line 7076: FROM RA_CUSTOMER_TRX_ALL

7072: SELECT organization_id
7073: FROM JAI_AR_TRXS
7074: WHERE trx_number = (
7075: SELECT recurred_from_trx_number
7076: FROM RA_CUSTOMER_TRX_ALL
7077: WHERE customer_trx_id = v_header_id
7078: );
7079:
7080: CURSOR CREATED_FROM_CUR IS

Line 7082: FROM ra_customer_trx_all

7078: );
7079:
7080: CURSOR CREATED_FROM_CUR IS
7081: SELECT created_from
7082: FROM ra_customer_trx_all
7083: WHERE customer_trx_id = v_header_id;
7084:
7085: /*CURSOR ROW_ID_CUR IS
7086: SELECT rowid FROM RA_CUSTOMER_TRX_ALL

Line 7086: SELECT rowid FROM RA_CUSTOMER_TRX_ALL

7082: FROM ra_customer_trx_all
7083: WHERE customer_trx_id = v_header_id;
7084:
7085: /*CURSOR ROW_ID_CUR IS
7086: SELECT rowid FROM RA_CUSTOMER_TRX_ALL
7087: WHERE customer_trx_id = v_header_id;*//*commented by rchandan for bug#4479131*/
7088:
7089:
7090: Cursor transaction_type_cur IS

Line 7092: From RA_CUST_TRX_TYPES_ALL a, RA_CUSTOMER_TRX_ALL b

7088:
7089:
7090: Cursor transaction_type_cur IS
7091: Select a.type
7092: From RA_CUST_TRX_TYPES_ALL a, RA_CUSTOMER_TRX_ALL b
7093: Where a.cust_trx_type_id = b.cust_trx_type_id
7094: And b.customer_trx_id = v_header_id
7095: And (a.org_id = pr_new.org_id
7096: OR

Line 7371: FROM RA_CUSTOMER_TRX_ALL A

7367:
7368: /* Bind variables customer_id , org_id to be retrieved in the db trigger */
7369: Cursor bind_cur IS
7370: SELECT A.org_id,A.bill_to_customer_id,NVL(A.bill_to_site_use_id,0) /*Bug 8371741 - Modifed to use Bill to Account*/
7371: FROM RA_CUSTOMER_TRX_ALL A
7372: WHERE customer_trx_id = v_header_id;
7373:
7374: Cursor header_info_cur IS
7375: SELECT set_of_books_id, invoice_currency_code, exchange_rate_type, exchange_date,

Line 7377: FROM RA_CUSTOMER_TRX_ALL

7373:
7374: Cursor header_info_cur IS
7375: SELECT set_of_books_id, invoice_currency_code, exchange_rate_type, exchange_date,
7376: exchange_rate, trx_date
7377: FROM RA_CUSTOMER_TRX_ALL
7378: WHERE customer_trx_id = v_header_id;
7379:
7380: Cursor tax_id_cur(p_tax_category_id IN Number) IS
7381: SELECT line_no

Line 7410: FROM RA_CUSTOMER_TRX_ALL

7406: SELECT organization_id, location_id--Added by Xiao Lv for bug 10091373
7407: FROM JAI_AR_TRXS
7408: WHERE trx_number = (
7409: SELECT recurred_from_trx_number
7410: FROM RA_CUSTOMER_TRX_ALL
7411: WHERE customer_trx_id = v_header_id
7412: );
7413:
7414: CURSOR CREATED_FROM_CUR IS

Line 7416: FROM ra_customer_trx_all

7412: );
7413:
7414: CURSOR CREATED_FROM_CUR IS
7415: SELECT created_from , trx_date
7416: FROM ra_customer_trx_all
7417: WHERE customer_trx_id = v_header_id;
7418:
7419: /*CURSOR ROW_ID_CUR IS
7420: SELECT rowid FROM RA_CUSTOMER_TRX_ALL

Line 7420: SELECT rowid FROM RA_CUSTOMER_TRX_ALL

7416: FROM ra_customer_trx_all
7417: WHERE customer_trx_id = v_header_id;
7418:
7419: /*CURSOR ROW_ID_CUR IS
7420: SELECT rowid FROM RA_CUSTOMER_TRX_ALL
7421: WHERE customer_trx_id = v_header_id;*//*commented by rchandan for bug#4479131*/
7422:
7423: CURSOR ONCE_COMPLETE_FLAG_CUR IS
7424: SELECT once_completed_flag

Line 7431: From RA_CUST_TRX_TYPES_ALL a, RA_CUSTOMER_TRX_ALL b

7427:
7428:
7429: Cursor transaction_type_cur IS
7430: Select a.type
7431: From RA_CUST_TRX_TYPES_ALL a, RA_CUSTOMER_TRX_ALL b
7432: Where a.cust_trx_type_id = b.cust_trx_type_id
7433: And b.customer_trx_id = v_header_id
7434: And ( a.org_id = pr_new.org_id
7435: OR

Line 7845: FROM RA_CUST_TRX_TYPES_ALL A, RA_CUSTOMER_TRX_ALL b

7841: -- 6369471
7842: -- cursor to get transaction type
7843: CURSOR c_transaction_type IS
7844: SELECT A.TYPE
7845: FROM RA_CUST_TRX_TYPES_ALL A, RA_CUSTOMER_TRX_ALL b
7846: WHERE A.cust_trx_type_id = b.cust_trx_type_id
7847: AND b.customer_trx_id = r_new.customer_trx_id
7848: AND NVL(A.org_id,0) = NVL(r_new.org_id,0);
7849:

Line 7859: from ra_customer_trx_all

7855: select trx_number, trx_date, batch_source_id, set_of_books_id
7856: , primary_salesrep_id ,invoice_currency_code, exchange_rate_type
7857: , exchange_date, exchange_rate
7858: , legal_entity_id -- 6012570
7859: from ra_customer_trx_all
7860: where customer_trx_id = r_new.customer_trx_id;
7861: r_ra_customer_trx c_ra_customer_trx%rowtype;
7862:
7863: cursor c_jai_ra_customer_trx is