DBA Data[Home] [Help]

APPS.PO_RCVIERR_XMLP_PKG dependencies on RCV_TRANSACTIONS_INTERFACE

Line 36: RCV_TRANSACTIONS_INTERFACE RTI

32: SELECT
33: RTI.INTERFACE_TRANSACTION_ID
34: FROM
35: PO_INTERFACE_ERRORS POI,
36: RCV_TRANSACTIONS_INTERFACE RTI
37: WHERE POI.INTERFACE_LINE_ID = RTI.INTERFACE_TRANSACTION_ID
38: AND POI.INTERFACE_TYPE = 'RCV-856'
39: AND ( ( TRUNC(TO_DATE(TO_CHAR(POI.CREATION_DATE
40: ,'DD-MON-YYYY')

Line 56: RCV_TRANSACTIONS_INTERFACE RTI

52: SELECT
53: RTI.INTERFACE_TRANSACTION_ID
54: FROM
55: PO_INTERFACE_ERRORS POI,
56: RCV_TRANSACTIONS_INTERFACE RTI
57: WHERE POI.INTERFACE_TRANSACTION_ID = RTI.INTERFACE_TRANSACTION_ID
58: AND POI.INTERFACE_TYPE in ( 'RECEIVE' , 'DELIVER' )
59: AND ( ( TRUNC(TO_DATE(TO_CHAR(POI.CREATION_DATE
60: ,'DD-MON-YYYY')