APPS.OE_VERIFY_PAYMENT_PUB dependencies on IBY_TRANS_ALL_V

Line 2950: FROM IBY_TRANS_ALL_V A

2946: FROM IBY_TANGIBLE IT
2947: WHERE IT.REFINFO = :ref_info
2948: AND EXISTS
2949: (SELECT ''Voice Auth Requested''
2950: FROM IBY_TRANS_ALL_V A
2951: WHERE A.REQTYPE = ''ORAPMTREQ''
2952: AND A.STATUS = 21
2953: AND A.TANGIBLEID = IT.TANGIBLEID)
2954: AND NOT

Line 2957: FROM IBY_TRANS_ALL_V B

2953: AND A.TANGIBLEID = IT.TANGIBLEID)
2954: AND NOT
2955: EXISTS
2956: (SELECT ''Voice Auth Successful''
2957: FROM IBY_TRANS_ALL_V B
2958: WHERE B.REQTYPE = ''ORAPMTREQ''
2959: AND B.STATUS = 0
2960: AND B.TANGIBLEID = IT.TANGIBLEID)';
2961:

Line 4455: l_sql_stmt := 'SELECT ''Y'' FROM IBY_TRANS_ALL_V

4451: IF l_debug_level > 0 THEN
4452: oe_debug_pub.add( 'OEXPVPMB: SQL STATEMENT TO CHECK IF TRANSACTION HAS BEEN CAPTURED' ) ;
4453: END IF;
4454: --
4455: l_sql_stmt := 'SELECT ''Y'' FROM IBY_TRANS_ALL_V
4456: WHERE TRANSACTIONID = :trxn_id
4457: AND ((REQTYPE = ''ORAPMTCAPTURE'')
4458: OR (REQTYPE = ''ORAPMTREQ'' AND AUTHTYPE = ''AUTHCAPTURE''))
4459: AND NVL(AMOUNT, 0) > 0

Line 4610: FROM IBY_TRANS_ALL_V ITAV

4606: l_sql_stmt := 'UPDATE IBY_TANGIBLE IT
4607: SET IT.REFINFO = :ref_info1
4608: WHERE IT.TANGIBLEID IN
4609: (SELECT DISTINCT ITAV.TANGIBLEID
4610: FROM IBY_TRANS_ALL_V ITAV
4611: WHERE ITAV.REQTYPE = ''ORAPMTREQ''
4612: AND ITAV.ECAPPID != 660
4613: AND ITAV.AUTHCODE = :auth_code
4614: AND trunc(ITAV.UPDATEDATE) = trunc(:auth_date) --5932506

Line 4635: FROM IBY_TRANS_ALL_V ITAV

4631: /* UPDATE IBY_TANGIBLE IT
4632: SET IT.REFINFO = l_ref_info
4633: WHERE IT.TANGIBLEID IN
4634: (SELECT DISTINCT ITAV.TANGIBLEID
4635: FROM IBY_TRANS_ALL_V ITAV
4636: WHERE ITAV.REQTYPE = 'ORAPMTREQ'
4637: AND ITAV.ECAPPID <> 660
4638: AND ITAV.AUTHCODE = l_credit_card_approval_code
4639: AND trunc(ITAV.UPDATEDATE) = trunc(l_credit_card_approval_date) --5932506

Line 4648: FROM IBY_TRANS_ALL_V ITAV

4644: UPDATE IBY_TANGIBLE IT
4645: SET IT.REFINFO = l_ref_info
4646: WHERE IT.TANGIBLEID IN
4647: (SELECT DISTINCT ITAV.TANGIBLEID
4648: FROM IBY_TRANS_ALL_V ITAV
4649: WHERE ITAV.REQTYPE = 'ORAPMTREQ'
4650: AND ITAV.AUTHCODE = l_credit_card_approval_code
4651: AND trunc(ITAV.UPDATEDATE) = trunc(l_credit_card_approval_date)
4652: AND (( ITAV.ECAPPID = 697

Line 4685: FROM IBY_TRANS_ALL_V A

4681: END IF;
4682: --
4683: l_sql_stmt := 'SELECT TRANSACTIONID, TANGIBLEID
4684: FROM (SELECT A.TRANSACTIONID, A.TANGIBLEID
4685: FROM IBY_TRANS_ALL_V A
4686: WHERE A.AUTHCODE = :auth_code
4687: AND trunc(A.UPDATEDATE) = trunc(:auth_date) --5932506
4688: AND A.REQTYPE = ''ORAPMTREQ''
4689: AND A.STATUS = 0

Line 4693: FROM IBY_TRANS_ALL_V B

4689: AND A.STATUS = 0
4690: AND A.REFINFO = :ref_info
4691: AND NOT
4692: EXISTS (SELECT ''Trxn Already Voided''
4693: FROM IBY_TRANS_ALL_V B
4694: WHERE B.TANGIBLEID = A.TANGIBLEID
4695: AND B.REQTYPE = ''ORAPMTVOID''
4696: AND B.STATUS = 0)
4697: ORDER BY A.UPDATEDATE DESC)

Line 4779: FROM IBY_TRANS_ALL_V A

4775: --
4776: -- Create the query string
4777: l_sql_stmt := 'SELECT TRANSACTIONID, TANGIBLEID, AUTHCODE, UPDATEDATE, AMOUNT
4778: FROM (SELECT A.TRANSACTIONID, A.TANGIBLEID, A.AUTHCODE, A.UPDATEDATE, A.AMOUNT
4779: FROM IBY_TRANS_ALL_V A
4780: WHERE A.REFINFO = :ref_info
4781: AND A.REQTYPE = ''ORAPMTREQ''
4782: AND A.ECAPPID = 660
4783: AND A.STATUS = 0

Line 4787: FROM IBY_TRANS_ALL_V B

4783: AND A.STATUS = 0
4784: AND A.AUTHCODE IS NOT NULL
4785: AND NOT
4786: EXISTS (SELECT ''Trxn Already Captured or Voided''
4787: FROM IBY_TRANS_ALL_V B
4788: WHERE B.TANGIBLEID = A.TANGIBLEID
4789: AND ((B.REQTYPE = ''ORAPMTVOID'')
4790: OR (B.REQTYPE = ''ORAPMTCAPTURE'')
4791: OR (B.REQTYPE = ''ORAPMTREQ''

Line 5083: FROM IBY_TRANS_ALL_V

5079: oe_debug_pub.add( 'OEXPVPMB: SQL STATEMENT TO FETCH TOTAL AMOUNT CAPTURED FOR THE ORDER' ) ;
5080: END IF;
5081: --
5082: l_sql_stmt := 'SELECT NVL(SUM(AMOUNT), 0)
5083: FROM IBY_TRANS_ALL_V
5084: WHERE REFINFO = :ref_info
5085: AND STATUS = 0
5086: AND ((REQTYPE = ''ORAPMTCAPTURE'')
5087: OR (REQTYPE = ''ORAPMTREQ'' AND AUTHTYPE = ''AUTHCAPTURE''))';