APPS.OE_VERIFY_PAYMENT_PUB dependencies on IBY_TRANS_ALL_V

Line 3023: FROM IBY_TRANS_ALL_V A

3019: FROM IBY_TANGIBLE IT
3020: WHERE IT.REFINFO = :ref_info
3021: AND EXISTS
3022: (SELECT ''Voice Auth Requested''
3023: FROM IBY_TRANS_ALL_V A
3024: WHERE A.REQTYPE = ''ORAPMTREQ''
3025: AND A.STATUS = 21
3026: AND A.TANGIBLEID = IT.TANGIBLEID)
3027: AND NOT

Line 3030: FROM IBY_TRANS_ALL_V B

3026: AND A.TANGIBLEID = IT.TANGIBLEID)
3027: AND NOT
3028: EXISTS
3029: (SELECT ''Voice Auth Successful''
3030: FROM IBY_TRANS_ALL_V B
3031: WHERE B.REQTYPE = ''ORAPMTREQ''
3032: AND B.STATUS = 0
3033: AND B.TANGIBLEID = IT.TANGIBLEID)';
3034:

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

4524: IF l_debug_level > 0 THEN
4525: oe_debug_pub.add( 'OEXPVPMB: SQL STATEMENT TO CHECK IF TRANSACTION HAS BEEN CAPTURED' ) ;
4526: END IF;
4527: --
4528: l_sql_stmt := 'SELECT ''Y'' FROM IBY_TRANS_ALL_V
4529: WHERE TRANSACTIONID = :trxn_id
4530: AND ((REQTYPE = ''ORAPMTCAPTURE'')
4531: OR (REQTYPE = ''ORAPMTREQ'' AND AUTHTYPE = ''AUTHCAPTURE''))
4532: AND NVL(AMOUNT, 0) > 0

Line 4683: FROM IBY_TRANS_ALL_V ITAV

4679: l_sql_stmt := 'UPDATE IBY_TANGIBLE IT
4680: SET IT.REFINFO = :ref_info1
4681: WHERE IT.TANGIBLEID IN
4682: (SELECT DISTINCT ITAV.TANGIBLEID
4683: FROM IBY_TRANS_ALL_V ITAV
4684: WHERE ITAV.REQTYPE = ''ORAPMTREQ''
4685: AND ITAV.ECAPPID != 660
4686: AND ITAV.AUTHCODE = :auth_code
4687: AND trunc(ITAV.UPDATEDATE) = trunc(:auth_date) --5932506

Line 4708: FROM IBY_TRANS_ALL_V ITAV

4704: /* UPDATE IBY_TANGIBLE IT
4705: SET IT.REFINFO = l_ref_info
4706: WHERE IT.TANGIBLEID IN
4707: (SELECT DISTINCT ITAV.TANGIBLEID
4708: FROM IBY_TRANS_ALL_V ITAV
4709: WHERE ITAV.REQTYPE = 'ORAPMTREQ'
4710: AND ITAV.ECAPPID <> 660
4711: AND ITAV.AUTHCODE = l_credit_card_approval_code
4712: AND trunc(ITAV.UPDATEDATE) = trunc(l_credit_card_approval_date) --5932506

Line 4721: FROM IBY_TRANS_ALL_V ITAV

4717: UPDATE IBY_TANGIBLE IT
4718: SET IT.REFINFO = l_ref_info
4719: WHERE IT.TANGIBLEID IN
4720: (SELECT DISTINCT ITAV.TANGIBLEID
4721: FROM IBY_TRANS_ALL_V ITAV
4722: WHERE ITAV.REQTYPE = 'ORAPMTREQ'
4723: AND ITAV.AUTHCODE = l_credit_card_approval_code
4724: AND trunc(ITAV.UPDATEDATE) = trunc(l_credit_card_approval_date)
4725: AND (( ITAV.ECAPPID = 697

Line 4758: FROM IBY_TRANS_ALL_V A

4754: END IF;
4755: --
4756: l_sql_stmt := 'SELECT TRANSACTIONID, TANGIBLEID
4757: FROM (SELECT A.TRANSACTIONID, A.TANGIBLEID
4758: FROM IBY_TRANS_ALL_V A
4759: WHERE A.AUTHCODE = :auth_code
4760: AND trunc(A.UPDATEDATE) = trunc(:auth_date) --5932506
4761: AND A.REQTYPE = ''ORAPMTREQ''
4762: AND A.STATUS = 0

Line 4766: FROM IBY_TRANS_ALL_V B

4762: AND A.STATUS = 0
4763: AND A.REFINFO = :ref_info
4764: AND NOT
4765: EXISTS (SELECT ''Trxn Already Voided''
4766: FROM IBY_TRANS_ALL_V B
4767: WHERE B.TANGIBLEID = A.TANGIBLEID
4768: AND B.REQTYPE = ''ORAPMTVOID''
4769: AND B.STATUS = 0)
4770: ORDER BY A.UPDATEDATE DESC)

Line 4852: FROM IBY_TRANS_ALL_V A

4848: --
4849: -- Create the query string
4850: l_sql_stmt := 'SELECT TRANSACTIONID, TANGIBLEID, AUTHCODE, UPDATEDATE, AMOUNT
4851: FROM (SELECT A.TRANSACTIONID, A.TANGIBLEID, A.AUTHCODE, A.UPDATEDATE, A.AMOUNT
4852: FROM IBY_TRANS_ALL_V A
4853: WHERE A.REFINFO = :ref_info
4854: AND A.REQTYPE = ''ORAPMTREQ''
4855: AND A.ECAPPID = 660
4856: AND A.STATUS = 0

Line 4860: FROM IBY_TRANS_ALL_V B

4856: AND A.STATUS = 0
4857: AND A.AUTHCODE IS NOT NULL
4858: AND NOT
4859: EXISTS (SELECT ''Trxn Already Captured or Voided''
4860: FROM IBY_TRANS_ALL_V B
4861: WHERE B.TANGIBLEID = A.TANGIBLEID
4862: AND ((B.REQTYPE = ''ORAPMTVOID'')
4863: OR (B.REQTYPE = ''ORAPMTCAPTURE'')
4864: OR (B.REQTYPE = ''ORAPMTREQ''

Line 5156: FROM IBY_TRANS_ALL_V

5152: oe_debug_pub.add( 'OEXPVPMB: SQL STATEMENT TO FETCH TOTAL AMOUNT CAPTURED FOR THE ORDER' ) ;
5153: END IF;
5154: --
5155: l_sql_stmt := 'SELECT NVL(SUM(AMOUNT), 0)
5156: FROM IBY_TRANS_ALL_V
5157: WHERE REFINFO = :ref_info
5158: AND STATUS = 0
5159: AND ((REQTYPE = ''ORAPMTCAPTURE'')
5160: OR (REQTYPE = ''ORAPMTREQ'' AND AUTHTYPE = ''AUTHCAPTURE''))';