APPS.AR_EXTRACT_DOCUMENT dependencies on AR_DOCUMENT_TRANSFERS

Line 29: from ar_document_transfers xfr,

25: l_subject VARCHAR2(200);
26:
27: CURSOR c_pending_trx IS
28: select trx.customer_trx_id
29: from ar_document_transfers xfr,
30: ra_customer_trx trx
31: where xfr.status = 'WAITING' and
32: xfr.source_id = trx.customer_trx_id and
33: trx.PRINTING_PENDING <> 'N' and

Line 63: insert into ar_document_transfers

59: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('l_trx_date_high:'||to_char(l_trx_date_high)); end if;
60:
61: ar_doc_transfer_standard.updateStatus;
62:
63: insert into ar_document_transfers
64: ( DOCUMENT_TRANSFER_ID,
65: SOURCE_ID,
66: SOURCE_TABLE,
67: TP_SOURCE_TABLE,

Line 84: (select AR_DOCUMENT_TRANSFERS_S.nextval,

80: LAST_UPDATED_BY,
81: LAST_SUBMISSION_DATE,
82: DOCUMENT_MSGID
83: )
84: (select AR_DOCUMENT_TRANSFERS_S.nextval,
85: SOURCE_ID,
86: SOURCE_TABLE,
87: TP_SOURCE_TABLE,
88: TP_SOURCE_ID,

Line 103: from ar_document_transfers_v d

99: SYSDATE,
100: FND_GLOBAL.USER_ID,
101: NULL,
102: NULL
103: from ar_document_transfers_v d
104: where (l_trx_class is null or d.trx_class = l_trx_class) and
105: (l_trx_type_id is null or d.trx_type_id = l_trx_type_id) and
106: (l_trx_number_low is null or l_trx_number_low <= d.trx_number) and
107: (l_trx_number_high is null or d.trx_number <= l_trx_number_high) and

Line 124: where customer_trx_id in (select source_id from ar_document_transfers where status = 'WAITING') and

120: PRINTING_COUNT = 1,
121: PRINTING_LAST_PRINTED = sysdate,
122: PRINTING_ORIGINAL_DATE = sysdate,
123: LAST_PRINTED_SEQUENCE_NUM = 1
124: where customer_trx_id in (select source_id from ar_document_transfers where status = 'WAITING') and
125: PRINTING_PENDING <> 'N' and
126: PRINTING_COUNT is null and
127: PRINTING_LAST_PRINTED is null and
128: PRINTING_ORIGINAL_DATE is null and