Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Error in Autoinvoice Master reoprt

Status
Not open for further replies.
jcasas23

jcasas23

IS-IT--Management
Oct 10, 2003
54
MX
I need an Urgent Help. I will appreciate your feedback.

When I run this report, the application show me the follow error:

+---------------------------------------------------------------------------+
Oracle Receivables: Version : 7.0.152 - Development

Copyright (c) Oracle Corporation 1979, 1991. All rights reserved.

RAXTRX module: Autoinvoice Import Program
+---------------------------------------------------------------------------+

Current system time is 24-AUG-2004 08:22:54

+---------------------------------------------------------------------------+

raaini()+ Current system time is 24-AUG-2004 08:22:55
raaapx()+ Current system time is 24-AUG-2004 08:22:55
raaapx()- Current system time is 24-AUG-2004 08:22:55
raagbo()+ Current system time is 24-AUG-2004 08:22:55
Dumping data fetched from RA_BATCH_SOURCES
batch_source_name = FP
auto_trx_numbering_flag = Y
cust_trx_type_rule = I
sold_customer_rule = I
bill_customer_rule = I
bill_address_rule = I
bill_contact_rule = I
ship_customer_rule = I
ship_address_rule = I
ship_contact_rule = I
memo_reason_rule = I
term_rule = I
invoicing_rule_rule = I
accounting_rule_rule = I
unit_of_measure_rule = I
agreement_rule = I
inventory_item_rule = I
fob_point_rule = S
ship_via_rule = S
invalid_lines_rule = R
salesperson_rule = I
sales_credit_type_rule = I
accounting_flexfield_rule = I
invalid_tax_rate_rule = R
rev_acc_allocation_rule = P
gl_date_period_rule = A
create_clearing_flag = N
derive_date_flag = Y
sales_credit_rule = P
sales_territory_rule = I
receipt_method_rule = I
customer_bank_account_rule = I
related_document_rule = I
memo_line_rule = I
allow_sales_credit_flag = Y
raagbo()- Current system time is 24-AUG-2004 08:22:55
raaggi()+ Current system time is 24-AUG-2004 08:22:55
raagixpfx = 0
raagixtpf = 0
raagixddf = 1
raagixacf = 0
raagixrit = 1
raagixagd = 1
raagixatn = 1
raagixcte = 0
raagixdfd =
raagixctc = 0
raagixrmx = T
raagixfdx = 24-AUG-04
raagixbix =
raagixbsi = 1088
raagixbnx = FP
raagixoix = 104
raagixrix = 6263058
raagixpix = 20428
raagixpai = 222
raagixuix = 9150
raagixunx = JCASAS
raagixanx = AR
raagixlul = 6771346
raagixasc = 1
raagixrsf = 0
raagixcbf = 0
raagixuax = 1
Argtcm = 1
Argtvd = 0
raagixsnf = 1
raagixtao = 1
raagixptf = 1
raagixstf = 0
raagixrfi = 0
raagixtac = 0
raagixcai = 50133
raagixsbi = 1
raagixcpr = 2
raagixmau =
raagixmlx = 3
raagixmbx = 60000000
raagixafp = COM Cuenta
raagixifp = Artículo
raagixtfp =
Argbdf = 1
Argddo = -9999
raaggi()- Current system time is 24-AUG-2004 08:22:55
raaseb()+ Current system time is 24-AUG-2004 08:22:55
raaseb()- Current system time is 24-AUG-2004 08:22:55
arcdsu()+ Current system time is 24-AUG-2004 08:22:55
arcdsu() error level: 3 array size: 60000000 insert array size: 60000000
arcdsu() Use Invoice Accounting For Credit Memo: Y
arcdsu()- Current system time is 24-AUG-2004 08:22:55
raaini()- Current system time is 24-AUG-2004 08:22:55
raapft()+ Current system time is 24-AUG-2004 08:22:55
raagtr()+ Current system time is 24-AUG-2004 08:22:55
crb->raaucrpn = RAXTRX
crb->raaucrcr = 6263058
crb->raaucrnt = 0
crb->raaucrml = 3
raagtr()- Current system time is 24-AUG-2004 08:22:55
raamil()+ Current system time is 24-AUG-2004 08:22:55
raaasf()+ Current system time is 24-AUG-2004 08:22:55
raaasf()- Current system time is 24-AUG-2004 08:22:55
raaasf()+ Current system time is 24-AUG-2004 08:22:55
raaasf()- Current system time is 24-AUG-2004 08:22:55
raaasf()+ Current system time is 24-AUG-2004 08:22:55
raaasf()- Current system time is 24-AUG-2004 08:22:55
raaasf()+ Current system time is 24-AUG-2004 08:22:55
raaasf()- Current system time is 24-AUG-2004 08:22:55
raaasf()+ Current system time is 24-AUG-2004 08:22:55
raaasf()- Current system time is 24-AUG-2004 08:22:55
raaasf()+ Current system time is 24-AUG-2004 08:22:55
raaasf()- Current system time is 24-AUG-2004 08:22:55
raaasf()+ Current system time is 24-AUG-2004 08:22:55
raaasf()- Current system time is 24-AUG-2004 08:22:55
raaasf()+ Current system time is 24-AUG-2004 08:22:55
raaasf()- Current system time is 24-AUG-2004 08:22:55
raaasf()+ Current system time is 24-AUG-2004 08:22:55
raaasf()- Current system time is 24-AUG-2004 08:22:55
raaasf()+ Current system time is 24-AUG-2004 08:22:55
raaasf()- Current system time is 24-AUG-2004 08:22:55
raaasf()+ Current system time is 24-AUG-2004 08:22:55
raaasf()- Current system time is 24-AUG-2004 08:22:55
raaasf()+ Current system time is 24-AUG-2004 08:22:55
raaasf()- Current system time is 24-AUG-2004 08:22:55
raaasf()+ Current system time is 24-AUG-2004 08:22:55
raaasf()- Current system time is 24-AUG-2004 08:22:55
raaasf()+ Current system time is 24-AUG-2004 08:22:55
raaasf()- Current system time is 24-AUG-2004 08:22:55
raaasf()+ Current system time is 24-AUG-2004 08:22:55
raaasf()- Current system time is 24-AUG-2004 08:22:55
raaasf()+ Current system time is 24-AUG-2004 08:22:55
raaasf()- Current system time is 24-AUG-2004 08:22:55
raaasf()+ Current system time is 24-AUG-2004 08:22:55
raaasf()- Current system time is 24-AUG-2004 08:22:55
raaasf()+ Current system time is 24-AUG-2004 08:22:55
raaasf()- Current system time is 24-AUG-2004 08:22:55
raaasf()+ Current system time is 24-AUG-2004 08:22:55
raaasf()- Current system time is 24-AUG-2004 08:22:55
UPDATE RA_INTERFACE_LINES
SET
LAST_UPDATE_DATE = sysdate,
LAST_UPDATED_BY = 9150,
LAST_UPDATE_LOGIN = 6771346,
TRX_DATE = TRUNC(TRX_DATE),
GL_DATE = TRUNC(GL_DATE),
CONVERSION_DATE = TRUNC(CONVERSION_DATE),
PURCHASE_ORDER_DATE = TRUNC(PURCHASE_ORDER_DATE),
RULE_START_DATE = TRUNC(RULE_START_DATE),
SALES_ORDER_DATE = TRUNC(SALES_ORDER_DATE),
SHIP_DATE_ACTUAL = TRUNC(SHIP_DATE_ACTUAL),
CUSTOMER_TRX_ID = NULL,
INTERFACE_LINE_ID = NVL(INTERFACE_LINE_ID, RA_CUSTOMER_TRX_LINES_S.NEXTVAL)
WHERE NVL(INTERFACE_STATUS, '~') != 'P'
AND REQUEST_ID = 6263058
AND LINK_TO_LINE_ATTRIBUTE1 IS NULL
AND LINK_TO_LINE_ATTRIBUTE2 IS NULL
AND LINK_TO_LINE_ATTRIBUTE3 IS NULL
AND LINK_TO_LINE_ATTRIBUTE4 IS NULL
AND LINK_TO_LINE_ATTRIBUTE5 IS NULL
AND LINK_TO_LINE_ATTRIBUTE6 IS NULL
AND LINK_TO_LINE_ATTRIBUTE7 IS NULL
AND LINK_TO_LINE_ATTRIBUTE8 IS NULL
AND LINK_TO_LINE_ATTRIBUTE9 IS NULL
AND LINK_TO_LINE_ATTRIBUTE10 IS NULL
AND LINK_TO_LINE_ATTRIBUTE11 IS NULL
AND LINK_TO_LINE_ATTRIBUTE12 IS NULL
AND LINK_TO_LINE_ATTRIBUTE13 IS NULL
AND LINK_TO_LINE_ATTRIBUTE14 IS NULL
AND LINK_TO_LINE_ATTRIBUTE15 IS NULL

len = 1108
8 rows updated Current system time is 24-AUG-2004 08:22:55
raagtf()+ Current system time is 24-AUG-2004 08:22:55
raagtf()- Current system time is 24-AUG-2004 08:22:55
raaasf()+ Current system time is 24-AUG-2004 08:22:55
raaasf()- Current system time is 24-AUG-2004 08:22:55
raaasf()+ Current system time is 24-AUG-2004 08:22:55
raaasf()- Current system time is 24-AUG-2004 08:22:55
raaasf()+ Current system time is 24-AUG-2004 08:22:55
raaasf()- Current system time is 24-AUG-2004 08:22:55
raaasf()+ Current system time is 24-AUG-2004 08:22:55
raaasf()- Current system time is 24-AUG-2004 08:22:55
raaasf()+ Current system time is 24-AUG-2004 08:22:55
raaasf()- Current system time is 24-AUG-2004 08:22:55
raaasf()+ Current system time is 24-AUG-2004 08:22:55
raaasf()- Current system time is 24-AUG-2004 08:22:55
raaasf()+ Current system time is 24-AUG-2004 08:22:55
raaasf()- Current system time is 24-AUG-2004 08:22:55
raaasf()+ Current system time is 24-AUG-2004 08:22:55
raaasf()- Current system time is 24-AUG-2004 08:22:55
raaasf()+ Current system time is 24-AUG-2004 08:22:55
raaasf()- Current system time is 24-AUG-2004 08:22:55
raaasf()+ Current system time is 24-AUG-2004 08:22:55
raaasf()- Current system time is 24-AUG-2004 08:22:55
raaasf()+ Current system time is 24-AUG-2004 08:22:55
raaasf()- Current system time is 24-AUG-2004 08:22:55
raaasf()+ Current system time is 24-AUG-2004 08:22:55
raaasf()- Current system time is 24-AUG-2004 08:22:55
raaasf()+ Current system time is 24-AUG-2004 08:22:55
raaasf()- Current system time is 24-AUG-2004 08:22:55
raaasf()+ Current system time is 24-AUG-2004 08:22:55
raaasf()- Current system time is 24-AUG-2004 08:22:55
raaasf()+ Current system time is 24-AUG-2004 08:22:55
raaasf()- Current system time is 24-AUG-2004 08:22:55
raaasf()+ Current system time is 24-AUG-2004 08:22:55
raaasf()- Current system time is 24-AUG-2004 08:22:55
raaasf()+ Current system time is 24-AUG-2004 08:22:55
raaasf()- Current system time is 24-AUG-2004 08:22:55
raaasf()+ Current system time is 24-AUG-2004 08:22:55
raaasf()- Current system time is 24-AUG-2004 08:22:55
raaasf()+ Current system time is 24-AUG-2004 08:22:55
raaasf()- Current system time is 24-AUG-2004 08:22:55
raaasf()+ Current system time is 24-AUG-2004 08:22:55
raaasf()- Current system time is 24-AUG-2004 08:22:55
raaasf()+ Current system time is 24-AUG-2004 08:22:55
raaasf()- Current system time is 24-AUG-2004 08:22:55
raaasf()+ Current system time is 24-AUG-2004 08:22:55
raaasf()- Current system time is 24-AUG-2004 08:22:55
UPDATE RA_INTERFACE_LINES L1
SET REQUEST_ID = 6263058,
LAST_UPDATE_DATE = sysdate,
LAST_UPDATED_BY = 9150,
LAST_UPDATE_LOGIN = 6771346,
CUSTOMER_TRX_ID = NULL,
INTERFACE_LINE_ID = NVL(INTERFACE_LINE_ID,
RA_CUSTOMER_TRX_LINES_S.NEXTVAL),
LINK_TO_LINE_ID =
(
SELECT INTERFACE_LINE_ID
FROM RA_INTERFACE_LINES L2
WHERE L2.REQUEST_ID = 6263058
AND L2.INTERFACE_LINE_CONTEXT = 'ORDER ENTRY'
AND L1.LINK_TO_LINE_CONTEXT = L2.INTERFACE_LINE_CONTEXT
AND L1.LINK_TO_LINE_ATTRIBUTE1 = L2.INTERFACE_LINE_ATTRIBUTE1
AND L1.LINK_TO_LINE_ATTRIBUTE2 = L2.INTERFACE_LINE_ATTRIBUTE2
AND L1.LINK_TO_LINE_ATTRIBUTE3 = L2.INTERFACE_LINE_ATTRIBUTE3
AND L1.LINK_TO_LINE_ATTRIBUTE4 = L2.INTERFACE_LINE_ATTRIBUTE4
AND L1.LINK_TO_LINE_ATTRIBUTE5 = L2.INTERFACE_LINE_ATTRIBUTE5
AND L1.LINK_TO_LINE_ATTRIBUTE6 = L2.INTERFACE_LINE_ATTRIBUTE6
AND L1.LINK_TO_LINE_ATTRIBUTE7 = L2.INTERFACE_LINE_ATTRIBUTE7
)
WHERE NVL(INTERFACE_STATUS, '~') != 'P'
AND (REQUEST_ID IS NULL OR REQUEST_ID IN (6263058)
)
AND EXISTS
(
SELECT 'x'
FROM RA_INTERFACE_LINES L2
WHERE L2.REQUEST_ID = 6263058
AND L2.INTERFACE_LINE_CONTEXT = 'ORDER ENTRY'
AND L1.LINK_TO_LINE_CONTEXT = L2.INTERFACE_LINE_CONTEXT
AND L1.LINK_TO_LINE_ATTRIBUTE1 = L2.INTERFACE_LINE_ATTRIBUTE1
AND L1.LINK_TO_LINE_ATTRIBUTE2 = L2.INTERFACE_LINE_ATTRIBUTE2
AND L1.LINK_TO_LINE_ATTRIBUTE3 = L2.INTERFACE_LINE_ATTRIBUTE3
AND L1.LINK_TO_LINE_ATTRIBUTE4 = L2.INTERFACE_LINE_ATTRIBUTE4
AND L1.LINK_TO_LINE_ATTRIBUTE5 = L2.INTERFACE_LINE_ATTRIBUTE5
AND L1.LINK_TO_LINE_ATTRIBUTE6 = L2.INTERFACE_LINE_ATTRIBUTE6
AND L1.LINK_TO_LINE_ATTRIBUTE7 = L2.INTERFACE_LINE_ATTRIBUTE7
)

len = 1651
0 rows updated Current system time is 24-AUG-2004 08:22:55
raamil()- Current system time is 24-AUG-2004 08:22:55
raamis()+ Current system time is 24-AUG-2004 08:22:55
SELECT S.ROWID,
L.INTERFACE_LINE_ID,
L.REQUEST_ID,
L.LAST_UPDATE_LOGIN,
L.LAST_UPDATED_BY
FROM RA_INTERFACE_SALESCREDITS S,
RA_INTERFACE_LINES L
WHERE L.REQUEST_ID = 6263058
AND L.LINE_TYPE = 'LINE'
AND L.INTERFACE_LINE_CONTEXT = 'ORDER ENTRY'
AND L.INTERFACE_LINE_CONTEXT = S.INTERFACE_LINE_CONTEXT
AND L.INTERFACE_LINE_ATTRIBUTE1 = S.INTERFACE_LINE_ATTRIBUTE1
AND L.INTERFACE_LINE_ATTRIBUTE2 = S.INTERFACE_LINE_ATTRIBUTE2
AND L.INTERFACE_LINE_ATTRIBUTE3 = S.INTERFACE_LINE_ATTRIBUTE3
AND L.INTERFACE_LINE_ATTRIBUTE4 = S.INTERFACE_LINE_ATTRIBUTE4
AND L.INTERFACE_LINE_ATTRIBUTE5 = S.INTERFACE_LINE_ATTRIBUTE5
AND L.INTERFACE_LINE_ATTRIBUTE6 = S.INTERFACE_LINE_ATTRIBUTE6
AND L.INTERFACE_LINE_ATTRIBUTE7 = S.INTERFACE_LINE_ATTRIBUTE7

8 row(s) updated
raamis()- Current system time is 24-AUG-2004 08:22:55
raamid()+ Current system time is 24-AUG-2004 08:22:55
SELECT
D.ROWID,
L.INTERFACE_LINE_ID,
L.REQUEST_ID,
L.LAST_UPDATE_LOGIN,
L.LAST_UPDATED_BY
FROM RA_INTERFACE_DISTRIBUTIONS D,
RA_INTERFACE_LINES L
WHERE L.REQUEST_ID = 6263058
AND L.INTERFACE_LINE_CONTEXT = 'ORDER ENTRY'
AND L.INTERFACE_LINE_CONTEXT = D.INTERFACE_LINE_CONTEXT
AND L.INTERFACE_LINE_ATTRIBUTE1 = D.INTERFACE_LINE_ATTRIBUTE1
AND L.INTERFACE_LINE_ATTRIBUTE2 = D.INTERFACE_LINE_ATTRIBUTE2
AND L.INTERFACE_LINE_ATTRIBUTE3 = D.INTERFACE_LINE_ATTRIBUTE3
AND L.INTERFACE_LINE_ATTRIBUTE4 = D.INTERFACE_LINE_ATTRIBUTE4
AND L.INTERFACE_LINE_ATTRIBUTE5 = D.INTERFACE_LINE_ATTRIBUTE5
AND L.INTERFACE_LINE_ATTRIBUTE6 = D.INTERFACE_LINE_ATTRIBUTE6
AND L.INTERFACE_LINE_ATTRIBUTE7 = D.INTERFACE_LINE_ATTRIBUTE7

len = 756

0 row(s) updated
raamid()- Current system time is 24-AUG-2004 08:22:55
raacet()+ Current system time is 24-AUG-2004 08:22:55

arp_auto_rule.refresh()+ 24-AUG-04 08:22:56
Updating ar_period_types:
row(s) updated: 0
Inserting into ar_period_types:
row(s) updated: 0
Deleting redundent ar_periods:
row(s) deleted: 0
Updating start, end dates in ar_periods:
row(s) updated: 0
Inserting into ar_periods:
row(s) inserted: 0
Updating period sequence number in ar_periods:
row(s) updated: 0

arp_auto_rule.refresh()- 24-AUG-04 08:22:56
raacet()- Current system time is 24-AUG-2004 08:22:56
raaurs()+ Current system time is 24-AUG-2004 08:22:56
raaurs()- Current system time is 24-AUG-2004 08:22:56
raapft()- Current system time is 24-AUG-2004 08:22:56

Validating : Current system time is 24-AUG-2004 08:22:56
raapu0()+ Current system time is 24-AUG-2004 08:22:56
raadci()+ Current system time is 24-AUG-2004 08:22:56
0 row(s) updated Current system time is 24-AUG-2004 08:22:56
raadci()- Current system time is 24-AUG-2004 08:22:56
raabsv()+ Current system time is 24-AUG-2004 08:22:56
raaasf()+ Current system time is 24-AUG-2004 08:22:56
raaasf()- Current system time is 24-AUG-2004 08:22:56
raabdf()+ Current system time is 24-AUG-2004 08:22:56
raabdf()- Current system time is 24-AUG-2004 08:22:56
raaasf()+ Current system time is 24-AUG-2004 08:22:56
raaasf()- Current system time is 24-AUG-2004 08:22:56
raabdf()+ Current system time is 24-AUG-2004 08:22:56
raabdf()- Current system time is 24-AUG-2004 08:22:56
raaasf()+ Current system time is 24-AUG-2004 08:22:56
raaasf()- Current system time is 24-AUG-2004 08:22:56
raabdf()+ Current system time is 24-AUG-2004 08:22:56
raabdf()- Current system time is 24-AUG-2004 08:22:56
raaasf()+ Current system time is 24-AUG-2004 08:22:56
raaasf()- Current system time is 24-AUG-2004 08:22:56
raabdf()+ Current system time is 24-AUG-2004 08:22:56
raabdf()- Current system time is 24-AUG-2004 08:22:56
raaasf()+ Current system time is 24-AUG-2004 08:22:56
raaasf()- Current system time is 24-AUG-2004 08:22:56
raabdf()+ Current system time is 24-AUG-2004 08:22:56
raabdf()- Current system time is 24-AUG-2004 08:22:56
raaasf()+ Current system time is 24-AUG-2004 08:22:56
raaasf()- Current system time is 24-AUG-2004 08:22:56
raabdf()+ Current system time is 24-AUG-2004 08:22:56
raabdf()- Current system time is 24-AUG-2004 08:22:56
raaasf()+ Current system time is 24-AUG-2004 08:22:56
raaasf()- Current system time is 24-AUG-2004 08:22:56
raabdf()+ Current system time is 24-AUG-2004 08:22:56
raabdf()- Current system time is 24-AUG-2004 08:22:56
raaasf()+ Current system time is 24-AUG-2004 08:22:56
raaasf()- Current system time is 24-AUG-2004 08:22:56
raabdf()+ Current system time is 24-AUG-2004 08:22:56
raabdf()- Current system time is 24-AUG-2004 08:22:56
raaasf()+ Current system time is 24-AUG-2004 08:22:56
raaasf()- Current system time is 24-AUG-2004 08:22:56
raabdf()+ Current system time is 24-AUG-2004 08:22:56
raabdf()- Current system time is 24-AUG-2004 08:22:57
raaasf()+ Current system time is 24-AUG-2004 08:22:57
raaasf()- Current system time is 24-AUG-2004 08:22:57
raaasf()+ Current system time is 24-AUG-2004 08:22:57
raaasf()- Current system time is 24-AUG-2004 08:22:57
raabdf()+ Current system time is 24-AUG-2004 08:22:57
raabdf()- Current system time is 24-AUG-2004 08:22:57
raaasf()+ Current system time is 24-AUG-2004 08:22:57
raaasf()- Current system time is 24-AUG-2004 08:22:57
raabdf()+ Current system time is 24-AUG-2004 08:22:57
raabdf()- Current system time is 24-AUG-2004 08:22:57
raaasf()+ Current system time is 24-AUG-2004 08:22:57
raaasf()- Current system time is 24-AUG-2004 08:22:57
raabdf()+ Current system time is 24-AUG-2004 08:22:57
raabdf()- Current system time is 24-AUG-2004 08:22:57
raaasf()+ Current system time is 24-AUG-2004 08:22:57
raaasf()- Current system time is 24-AUG-2004 08:22:57
raabdf()+ Current system time is 24-AUG-2004 08:22:57
raabdf()- Current system time is 24-AUG-2004 08:22:57
raaasf()+ Current system time is 24-AUG-2004 08:22:57
raaasf()- Current system time is 24-AUG-2004 08:22:57
raabdf()+ Current system time is 24-AUG-2004 08:22:57
raabdf()- Current system time is 24-AUG-2004 08:22:57
raaasf()+ Current system time is 24-AUG-2004 08:22:57
raaasf()- Current system time is 24-AUG-2004 08:22:57
raabdf()+ Current system time is 24-AUG-2004 08:22:57
raabdf()- Current system time is 24-AUG-2004 08:22:57
raaasf()+ Current system time is 24-AUG-2004 08:22:57
raaasf()- Current system time is 24-AUG-2004 08:22:57
raabdf()+ Current system time is 24-AUG-2004 08:22:57
raabdf()- Current system time is 24-AUG-2004 08:22:57
raaasf()+ Current system time is 24-AUG-2004 08:22:57
raaasf()- Current system time is 24-AUG-2004 08:22:57
raabdf()+ Current system time is 24-AUG-2004 08:22:57
raabdf()- Current system time is 24-AUG-2004 08:22:57
raaasf()+ Current system time is 24-AUG-2004 08:22:57
raaasf()- Current system time is 24-AUG-2004 08:22:57
raaasf()+ Current system time is 24-AUG-2004 08:22:57
raaasf()- Current system time is 24-AUG-2004 08:22:57
raaasf()+ Current system time is 24-AUG-2004 08:22:57
raaasf()- Current system time is 24-AUG-2004 08:22:57
raabdf()+ Current system time is 24-AUG-2004 08:22:57
raabdf()- Current system time is 24-AUG-2004 08:22:57
raaasf()+ Current system time is 24-AUG-2004 08:22:57
raaasf()- Current system time is 24-AUG-2004 08:22:57
raabdf()+ Current system time is 24-AUG-2004 08:22:57
raabdf()- Current system time is 24-AUG-2004 08:22:57
raaasf()+ Current system time is 24-AUG-2004 08:22:57
raaasf()- Current system time is 24-AUG-2004 08:22:57
raabdf()+ Current system time is 24-AUG-2004 08:22:57
raabdf()- Current system time is 24-AUG-2004 08:22:57
raaasf()+ Current system time is 24-AUG-2004 08:22:57
raaasf()- Current system time is 24-AUG-2004 08:22:57
raaasf()+ Current system time is 24-AUG-2004 08:22:57
raaasf()- Current system time is 24-AUG-2004 08:22:57
raaasf()+ Current system time is 24-AUG-2004 08:22:57
raaasf()- Current system time is 24-AUG-2004 08:22:57
raaasf()+ Current system time is 24-AUG-2004 08:22:57
raaasf()- Current system time is 24-AUG-2004 08:22:57
raaasf()+ Current system time is 24-AUG-2004 08:22:57
raaasf()- Current system time is 24-AUG-2004 08:22:57
raaasf()+ Current system time is 24-AUG-2004 08:22:57
raaasf()- Current system time is 24-AUG-2004 08:22:57
raaasf()+ Current system time is 24-AUG-2004 08:22:57
raaasf()- Current system time is 24-AUG-2004 08:22:57
raaasf()+ Current system time is 24-AUG-2004 08:22:57
raaasf()- Current system time is 24-AUG-2004 08:22:57
raaasf()+ Current system time is 24-AUG-2004 08:22:57
raaasf()- Current system time is 24-AUG-2004 08:22:57
raaasf()+ Current system time is 24-AUG-2004 08:22:57
raaasf()- Current system time is 24-AUG-2004 08:22:57
raaasf()+ Current system time is 24-AUG-2004 08:22:57
raaasf()- Current system time is 24-AUG-2004 08:22:57
raaasf()+ Current system time is 24-AUG-2004 08:22:57
raaasf()- Current system time is 24-AUG-2004 08:22:57
raaasf()+ Current system time is 24-AUG-2004 08:22:57
raaasf()- Current system time is 24-AUG-2004 08:22:57
raabdd()+ Current system time is 24-AUG-2004 08:22:57
raabdd()- Current system time is 24-AUG-2004 08:22:57
raaasf()+ Current system time is 24-AUG-2004 08:22:57
raaasf()- Current system time is 24-AUG-2004 08:22:57
raaasf()+ Current system time is 24-AUG-2004 08:22:57
raaasf()- Current system time is 24-AUG-2004 08:22:57
raaasf()+ Current system time is 24-AUG-2004 08:22:57
raaasf()- Current system time is 24-AUG-2004 08:22:57
raaasf()+ Current system time is 24-AUG-2004 08:22:57
raaasf()- Current system time is 24-AUG-2004 08:22:57
raaasf()+ Current system time is 24-AUG-2004 08:22:57
raaasf()- Current system time is 24-AUG-2004 08:22:57
raaasf()+ Current system time is 24-AUG-2004 08:22:57
raaasf()- Current system time is 24-AUG-2004 08:22:57
raaasf()+ Current system time is 24-AUG-2004 08:22:57
raaasf()- Current system time is 24-AUG-2004 08:22:57
raaasf()+ Current system time is 24-AUG-2004 08:22:57
raaasf()- Current system time is 24-AUG-2004 08:22:57
raaasf()+ Current system time is 24-AUG-2004 08:22:57
raaasf()- Current system time is 24-AUG-2004 08:22:57
raabdf()+ Current system time is 24-AUG-2004 08:22:57
raabdf()- Current system time is 24-AUG-2004 08:22:57
raaasf()+ Current system time is 24-AUG-2004 08:22:57
raaasf()- Current system time is 24-AUG-2004 08:22:57
raabdf()+ Current system time is 24-AUG-2004 08:22:57
raabdf()- Current system time is 24-AUG-2004 08:22:57
raaasf()+ Current system time is 24-AUG-2004 08:22:57
raaasf()- Current system time is 24-AUG-2004 08:22:57
raaasf()+ Current system time is 24-AUG-2004 08:22:57
raaasf()- Current system time is 24-AUG-2004 08:22:57
raaasf()+ Current system time is 24-AUG-2004 08:22:57
raaasf()- Current system time is 24-AUG-2004 08:22:57
raaasf()+ Current system time is 24-AUG-2004 08:22:57
raaasf()- Current system time is 24-AUG-2004 08:22:57
SELECT
L.CUST_TRX_TYPE_ID, DECODE(L.CUST_TRX_TYPE_ID,
'1023', '1023',
'1060', '1060',
'1061', '1061',
'1062', '1062',
'1063', '1063',
'1064', '1064',
'1065', '1065',
'1066', '1066',
'1067', '1067',
'1068', '1068',
'1075', '1075',
'1100', '1100',
'1140', '1140',
'1020', '1020',
'1021', '1021',
'1022', '1022',
'1025', '1025',
'1026', '1026',
'1027', '1027',
'1028', '1028',
'1029', '1029',
'1030', '1030',
'1031', '1031',
'1032', '1032',
'1180', '1180', -99),
L.INVOICING_RULE_ID, DECODE(L.INVOICING_RULE_ID,
'-2', '-2',
'-3', '-3',
NULL, NULL, -99),
L.TERM_ID, DECODE(L.TERM_ID,
'4', '4',
'5', '5',
'1000', '1000',
'1020', '1020',
'1021', '1021',
'1022', '1022',
'1023', '1023',
'1024', '1024',
'1025', '1025',
'1026', '1026',
'1027', '1027',
'1028', '1028',
'1029', '1029',
'1030', '1030',
'1031', '1031',
'1032', '1032',
'1033', '1033',
'1040', '1040',
'1060', '1060',
'1080', '1080',
'1100', '1100',
'1180', '1180',
'1120', '1120',
'1160', '1160',
'1140', '1140',
NULL, NULL, -99),
L.UOM_CODE, DECODE(L.UOM_CODE,
'EA', 'EA',
'MTR', 'MTR',
'KG', 'KG',
'LT', 'LT',
'CM', 'CM',
'KM', 'KM',
'GAL', 'GAL',
'M3', 'M3',
'CM3', 'CM3',
'Cm3', 'Cm3',
'HR', 'HR',
'MIN', 'MIN',
'SEG', 'SEG',
'Bt', 'Bt',
'OZ', 'OZ',
'PK', 'PK',
'PR', 'PR',
'RL', 'RL',
'ST', 'ST',
'TU', 'TU',
NULL, NULL, -99),
L.AGREEMENT_ID, DECODE(L.AGREEMENT_ID,
'1000', '1000',
'1040', '1040',
'1060', '1060',
'1020', '1020',
'1021', '1021',
NULL, NULL, -99),
L.FOB_POINT, DECODE(L.FOB_POINT,
'BUY', 'BUY',
'C.I.F. Destiny', 'C.I.F. Destiny',
'CPT Aeropuerto Cd. de México I', 'CPT Aeropuerto Cd. de México I',
'CUSTOMER SITE', 'CUSTOMER SITE',
'DAF Frontera Calexico, CA. Inc', 'DAF Frontera Calexico, CA. Inc',
'DAF Frontera Laredo, Tx. Incot', 'DAF Frontera Laredo, Tx. Incot',
'DAF Frontera Otay Mesa, Incote', 'DAF Frontera Otay Mesa, Incote',
'DAF Frontera Pearlington MS, I', 'DAF Frontera Pearlington MS, I',
'DDP GYP, México D.F. Incoterms', 'DDP GYP, México D.F. Incoterms',
'DDP IGSA México D.F. Incoterms', 'DDP IGSA México D.F. Incoterms',
'DDP Kenmex, Mexicali, B.C., In', 'DDP Kenmex, Mexicali, B.C., In',
'DDP Ottomotores, Mexico, D.F.', 'DDP Ottomotores, Mexico, D.F.',
'DDP Planelec, Mexico DF Incote', 'DDP Planelec, Mexico DF Incote',
'DDP Selmec Mexico D.F. Incoter', 'DDP Selmec Mexico D.F. Incoter',
'FACTORY', 'FACTORY',
'FCA Mexicali, B.C., Incoterms', 'FCA Mexicali, B.C., Incoterms',
'FCA Nuevo Laredo, Tamps., Inco', 'FCA Nuevo Laredo, Tamps., Inco',
'FCA Otay Mesa Incoterm 2000', 'FCA Otay Mesa Incoterm 2000',
'FCA Planta SLP, Incoterms 2000', 'FCA Planta SLP, Incoterms 2000',
'FCA Pto. Progreso, Yuc. Incote', 'FCA Pto. Progreso, Yuc. Incote',
'FCA Veracruz, Ver., Incoterms', 'FCA Veracruz, Ver., Incoterms',
'FOB Manzanillo Incoterms 2000', 'FOB Manzanillo Incoterms 2000',
'FOB Midbridge', 'FOB Midbridge',
'LAB Destino', 'LAB Destino',
'LAB Frontera', 'LAB Frontera',
'LAB Laredo,Texas', 'LAB Laredo,Texas',
'LOAD', 'LOAD',
'Libre a Bordo CUMSA', 'Libre a Bordo CUMSA',
'SEL', 'SEL',
'SHIP POINT', 'SHIP POINT',
NULL, NULL, -99),
L.SHIP_VIA, DECODE(L.SHIP_VIA,
'ALA', 'ALA',
'Aeromexpress', 'Aeromexpress',
'Almex', 'Almex',
'CFI', 'CFI',
'Coordinadora auto.', 'Coordinadora auto.',
'DHL', 'DHL',
'Egoba', 'Egoba',
'El cliente recoge', 'El cliente recoge',
'El cliente recoje', 'El cliente recoje',
'Eloy Martinez', 'Eloy Martinez',
'FLETES 2000', 'FLETES 2000',
'Flete Gare', 'Flete Gare',
'Flete Julian de Obregon', 'Flete Julian de Obregon',
'Fletes Alesa', 'Fletes Alesa',
'Fletes Crystal', 'Fletes Crystal',
'Fletes Hercel', 'Fletes Hercel',
'Fletes Mendoza', 'Fletes Mendoza',
'Fletes SLP-AGS', 'Fletes SLP-AGS',
'Fletes San Luis', 'Fletes San Luis',
'Fletes Segoviano', 'Fletes Segoviano',
'JUPECSA,S.A DE C.V.', 'JUPECSA,S.A DE C.V.',
'Jesus Flores', 'Jesus Flores',
'Juan Manuel Sanchez', 'Juan Manuel Sanchez',
'Mario Gonzalez', 'Mario Gonzalez',
'Martin Garcia', 'Martin Garcia',
'Mexpur', 'Mexpur',
'Motor inst C. Piloto', 'Motor inst C. Piloto',
'No Cargo por Flete', 'No Cargo por Flete',
'Roberto Quezada Reyna', 'Roberto Quezada Reyna',
'Senda Express', 'Senda Express',
'TRANSPORTES AS', 'TRANSPORTES AS',
'TRANSPORTES GARCIA', 'TRANSPORTES GARCIA',
'TUNSA', 'TUNSA',
'Transportes Perez', 'Transportes Perez',
'Transportes TAC', 'Transportes TAC',
'Trasportes Yuma', 'Trasportes Yuma',
'UPS', 'UPS',
NULL, NULL, -99),
L.ACCOUNTING_RULE_ID, DECODE(L.ACCOUNTING_RULE_ID,
'1', '1',
NULL, NULL, -99),
L.MEMO_LINE_ID, DECODE(L.MEMO_LINE_ID,
'1', '1',
'2', '2',
'8', '8',
NULL, NULL, -99),
DECODE(L.LINE_TYPE, 'LINE',
DECODE(ROUND(L.UNIT_SELLING_PRICE * L.QUANTITY, AOL.PRECISION),
AMOUNT, NULL, NULL, NULL, -99),
NULL),
L.RECEIPT_METHOD_ID, DECODE(L.RECEIPT_METHOD_ID,
'1000', '1000',
'1001', '1001',
'1002', '1002',
'1020', '1020',
'1040', '1040',
NULL, NULL, -99),
L.LINE_TYPE, DECODE(L.LINE_TYPE,
'CHARGES', 'CHARGES',
'FREIGHT', 'FREIGHT',
'TAX', 'TAX',
'LINE', 'LINE', -99),
L.CONVERSION_TYPE, DECODE(L.CONVERSION_TYPE,
'Corporate', 'Corporate',
'Spot', 'Spot',
'User', 'User',
'1000', '1000',
'1001', '1001',
'1020', '1020',
'EMU FIXED', 'EMU FIXED',
NULL, NULL, -99),
L.PRIMARY_SALESREP_ID, DECODE(L.PRIMARY_SALESREP_ID,
'-3', '-3',
'1042', '1042',
'1043', '1043',
'1044', '1044',
'1045', '1045',
'1046', '1046',
'1047', '1047',
'1048', '1048',
'1049', '1049',
'1050', '1050',
'1051', '1051',
'1052', '1052',
'1053', '1053',
'1054', '1054',
'1055', '1055',
'1056', '1056',
'1057', '1057',
'1058', '1058',
'1059', '1059',
'1060', '1060',
'1061', '1061',
'1080', '1080',
'1081', '1081',
'1100', '1100',
'1000', '1000',
'1001', '1001',
'1140', '1140',
'1385', '1385',
'1260', '1260',
'1280', '1280',
NULL, NULL, -99),
L.PRINTING_OPTION, DECODE(L.PRINTING_OPTION,
'NOT', 'NOT',
'PRI', 'PRI',
NULL, NULL, -99),
L.TAX_CODE, DECODE(L.TAX_CODE,
'IVA 0%', 'IVA 0%',
'IVA 15%', 'IVA 15%',
'IVA 60%', 'IVA 60%',
NULL, NULL, -99),
DECODE(L.AMOUNT, NULL, NULL,
DECODE(L.AMOUNT - DECODE(AOL.MINIMUM_ACCOUNTABLE_UNIT,
NULL, ROUND(L.AMOUNT, AOL.PRECISION),
ROUND(L.AMOUNT / AOL.MINIMUM_ACCOUNTABLE_UNIT) *
AOL.MINIMUM_ACCOUNTABLE_UNIT),
0, NULL, -99)),
DECODE(T.ALLOW_FREIGHT_FLAG,
'N', DECODE(L.LINE_TYPE, 'FREIGHT', -99, NULL),
NULL),
L.SET_OF_BOOKS_ID, DECODE(L.SET_OF_BOOKS_ID,
'1', '1',
NULL, NULL, -99),
L.CREDIT_METHOD_FOR_ACCT_RULE, DECODE(L.CREDIT_METHOD_FOR_ACCT_RULE,
'LIFO', 'LIFO',
'PRORATE', 'PRORATE',
'UNIT', 'UNIT',
NULL, NULL, -99),
L.CREDIT_METHOD_FOR_INSTALLMENTS, DECODE(L.CREDIT_METHOD_FOR_INSTALLMENTS,
'FIFO', 'FIFO',
'LIFO', 'LIFO',
'PRORATE', 'PRORATE',
NULL, NULL, -99),
DECODE(L.LINK_TO_LINE_ID,
NULL, DECODE(L.TRX_NUMBER, NULL, NULL, -99), NULL),
DECODE(L.TAX_PRECEDENCE, NULL, NULL, -99),
DECODE(T.TYPE,
'CM', DECODE(L.TERM_ID,
NULL, DECODE(L.TERM_NAME, NULL, NULL, -99),
-99),
NULL),
DECODE(T.TYPE, 'CM',
DECODE(L.REFERENCE_LINE_ID, NULL,
DECODE(L.REFERENCE_LINE_ATTRIBUTE1
||L.REFERENCE_LINE_ATTRIBUTE2
||L.REFERENCE_LINE_ATTRIBUTE3
||L.REFERENCE_LINE_ATTRIBUTE4
||L.REFERENCE_LINE_ATTRIBUTE5
||L.REFERENCE_LINE_ATTRIBUTE6
||L.REFERENCE_LINE_ATTRIBUTE7
||L.REFERENCE_LINE_ATTRIBUTE8
||L.REFERENCE_LINE_ATTRIBUTE9
||L.REFERENCE_LINE_ATTRIBUTE10,
NULL, DECODE(L.INVOICING_RULE_ID,
NULL, NULL, -99),
NULL), NULL), NULL),
DECODE(T.TYPE,
'CM', DECODE(L.RELATED_CUSTOMER_TRX_ID,
NULL, DECODE(L.RELATED_TRX_NUMBER, NULL, NULL, -99),
-99),
NULL),
DECODE(T.TYPE, 'CM', NULL,
DECODE(L.LINK_TO_LINE_ID, NULL,
DECODE(L.TERM_NAME,
NULL, DECODE(L.TERM_ID, NULL, -99, NULL)))),
DECODE(UPPER(L.CONVERSION_TYPE),
'USER', DECODE(L.CONVERSION_RATE, NULL, -99, NULL), NULL),
DECODE(UPPER(L.CONVERSION_TYPE), 'USER', NULL,
DECODE(L.CONVERSION_RATE, NULL, NULL, -99)),
DECODE(L.ACCOUNTING_RULE_ID,
NULL, DECODE(L.INVOICING_RULE_ID, NULL, NULL, -99),
DECODE(L.INVOICING_RULE_ID, NULL, -99,
DECODE(L.GL_DATE, NULL, NULL, -99))),
DECODE(L.LINE_TYPE,
'TAX', DECODE(L.AMOUNT,
NULL, DECODE(L.TAX_RATE, NULL, -99, NULL),
NULL),
NULL),
DECODE(L.LINE_TYPE,
'LINE', DECODE(L.LINK_TO_LINE_ID, NULL, NULL, -99),
'CHARGES', DECODE(L.LINK_TO_LINE_ID, NULL, NULL, 1075355360),
NULL),
DECODE(L.LINE_TYPE,
'TAX', DECODE(L.LINK_TO_LINE_ID, NULL, -99, NULL),
NULL),
L.ACCOUNTING_RULE_DURATION,
DECODE(DECODE(L.ACCOUNTING_RULE_DURATION, NULL, 'A', 'ACC_DUR' ),
DECODE(L.ACCOUNTING_RULE_ID,
'1', 'A',
NULL, 'A' ),
NULL, -99 ),
DECODE(L.MEMO_LINE_ID,
NULL, NULL,
DECODE(L.INVENTORY_ITEM_ID,
NULL, NULL,
-99)),
DECODE(L.LINE_TYPE,
'LINE', DECODE(L.CREDIT_METHOD_FOR_ACCT_RULE,
'UNIT', DECODE(L.QUANTITY, NULL, -99, NULL), NULL),
NULL),
DECODE(L.LINE_TYPE,
'TAX', DECODE(T.TYPE, 'CM', NULL,
DECODE(L.TAX_CODE, NULL, -99, NULL)),
NULL),
DECODE(L.LINE_TYPE,
'CHARGES',
DECODE(L.INVOICING_RULE_ID,
NULL, DECODE(L.INVOICING_RULE_NAME,
NULL, DECODE(L.ACCOUNTING_RULE_ID,
NULL, DECODE(L.ACCOUNTING_RULE_NAME,
NULL, NULL, -99),
-99), -99), -99),
NULL),
DECODE(L.LINE_TYPE,
'CHARGES', DECODE(L.UOM_CODE,
NULL, DECODE(L.UOM_NAME, NULL, NULL, -99), -99),
NULL),
DECODE(L.LINE_TYPE,
'CHARGES', DECODE(L.QUANTITY, 1, NULL, -1, NULL, -99),
NULL),
DECODE(L.LINE_TYPE,
'CHARGES', DECODE(T.TYPE, 'CM', NULL, 'DM', NULL, -99),
NULL),
DECODE(T.POST_TO_GL, 'N', DECODE(L.GL_DATE, NULL, NULL, -99),
NULL),
L.TAX_EXEMPT_FLAG, DECODE(L.TAX_EXEMPT_FLAG,
'R', 'R',
'S', 'S',
NULL, NULL, -99),
L.TAX_EXEMPT_REASON_CODE, DECODE(L.TAX_EXEMPT_REASON_CODE,
'R10UPGRADE', 'R10UPGRADE',
NULL, NULL, -99),
DECODE(L.LINE_TYPE, 'LINE',
DECODE(L.TAX_EXEMPT_FLAG, 'E',
DECODE(L.TAX_EXEMPT_REASON_CODE,
NULL, DECODE(L.TAX_EXEMPT_REASON_CODE_MEANING,
NULL, -99, NULL),
NULL),
NULL),
NULL),
DECODE(L.INTERFACE_LINE_CONTEXT, NULL, -99, NULL),
L.INTERFACE_LINE_ID
FROM RA_INTERFACE_LINES L, RA_CUST_TRX_TYPES T, FND_CURRENCIES AOL
WHERE L.REQUEST_ID = 6263058
AND L.CUST_TRX_TYPE_ID = T.CUST_TRX_TYPE_ID (+)
AND L.CURRENCY_CODE = AOL.CURRENCY_CODE (+)
len = 10902
raabsv()- Current system time is 24-AUG-2004 08:22:57
raavar()+ Current system time is 24-AUG-2004 08:22:57
raaamd()+ Current system time is 24-AUG-2004 08:22:57
raaamd()- Current system time is 24-AUG-2004 08:22:57
array_size = 32767

========== 2125048 ==========
CUST_TRX_TYPE_ID xxx1020xxx
INVOICING_RULE_ID xxxxxx
TERM_ID xxx1022xxx
UOM_CODE xxxEAxxx
AGREEMENT_ID xxxxxx
FOB_POINT xxxxxx
SHIP_VIA xxxMario Gonzalezxxx
ACCOUNTING_RULE_ID xxxxxx
MEMO_LINE_ID xxxxxx
RECEIPT_METHOD_ID xxxxxx
LINE_TYPE xxxLINExxx
CONVERSION_TYPE xxx1000xxx
PRIMARY_SALESREP_ID xxx1001xxx
PRINTING_OPTION xxxxxx
TAX_CODE xxxIVA 15%xxx
SET_OF_BOOKS_ID xxx1xxx
CREDIT_METHOD_FOR_ACCT_RULE xxxxxx
CREDIT_METHOD_FOR_INSTALLMENTS xxxxxx
ACCOUNTING_RULE_DURATION xxxxxx
TAX_EXEMPT_FLAG xxxSxxx
TAX_EXEMPT_REASON_CODE xxxxxx

========== 2125049 ==========
CUST_TRX_TYPE_ID xxx1020xxx
INVOICING_RULE_ID xxxxxx
TERM_ID xxx1022xxx
UOM_CODE xxxEAxxx
AGREEMENT_ID xxxxxx
FOB_POINT xxxxxx
SHIP_VIA xxxJUPECSA,S.A DE C.V.xxx
ACCOUNTING_RULE_ID xxxxxx
MEMO_LINE_ID xxxxxx
RECEIPT_METHOD_ID xxxxxx
LINE_TYPE xxxLINExxx
CONVERSION_TYPE xxx1000xxx
PRIMARY_SALESREP_ID xxx1001xxx
PRINTING_OPTION xxxxxx
TAX_CODE xxxIVA 15%xxx
SET_OF_BOOKS_ID xxx1xxx
CREDIT_METHOD_FOR_ACCT_RULE xxxxxx
CREDIT_METHOD_FOR_INSTALLMENTS xxxxxx
ACCOUNTING_RULE_DURATION xxxxxx
TAX_EXEMPT_FLAG xxxSxxx
TAX_EXEMPT_REASON_CODE xxxxxx

========== 2125050 ==========
CUST_TRX_TYPE_ID xxx1020xxx
INVOICING_RULE_ID xxxxxx
TERM_ID xxx1022xxx
UOM_CODE xxxEAxxx
AGREEMENT_ID xxxxxx
FOB_POINT xxxxxx
SHIP_VIA xxxJUPECSA,S.A DE C.V.xxx
ACCOUNTING_RULE_ID xxxxxx
MEMO_LINE_ID xxxxxx
RECEIPT_METHOD_ID xxxxxx
LINE_TYPE xxxLINExxx
CONVERSION_TYPE xxx1000xxx
PRIMARY_SALESREP_ID xxx1001xxx
PRINTING_OPTION xxxxxx
TAX_CODE xxxIVA 15%xxx
SET_OF_BOOKS_ID xxx1xxx
CREDIT_METHOD_FOR_ACCT_RULE xxxxxx
CREDIT_METHOD_FOR_INSTALLMENTS xxxxxx
ACCOUNTING_RULE_DURATION xxxxxx
TAX_EXEMPT_FLAG xxxSxxx
TAX_EXEMPT_REASON_CODE xxxxxx

========== 2125051 ==========
CUST_TRX_TYPE_ID xxx1020xxx
INVOICING_RULE_ID xxxxxx
TERM_ID xxx1022xxx
UOM_CODE xxxEAxxx
AGREEMENT_ID xxxxxx
FOB_POINT xxxxxx
SHIP_VIA xxxJUPECSA,S.A DE C.V.xxx
ACCOUNTING_RULE_ID xxxxxx
MEMO_LINE_ID xxxxxx
RECEIPT_METHOD_ID xxxxxx
LINE_TYPE xxxLINExxx
CONVERSION_TYPE xxx1000xxx
PRIMARY_SALESREP_ID xxx1001xxx
PRINTING_OPTION xxxxxx
TAX_CODE xxxIVA 15%xxx
SET_OF_BOOKS_ID xxx1xxx
CREDIT_METHOD_FOR_ACCT_RULE xxxxxx
CREDIT_METHOD_FOR_INSTALLMENTS xxxxxx
ACCOUNTING_RULE_DURATION xxxxxx
TAX_EXEMPT_FLAG xxxSxxx
TAX_EXEMPT_REASON_CODE xxxxxx

========== 2125052 ==========
CUST_TRX_TYPE_ID xxx1020xxx
INVOICING_RULE_ID xxxxxx
TERM_ID xxx1022xxx
UOM_CODE xxxEAxxx
AGREEMENT_ID xxxxxx
FOB_POINT xxxxxx
SHIP_VIA xxxJUPECSA,S.A DE C.V.xxx
ACCOUNTING_RULE_ID xxxxxx
MEMO_LINE_ID xxxxxx
RECEIPT_METHOD_ID xxxxxx
LINE_TYPE xxxLINExxx
CONVERSION_TYPE xxx1000xxx
PRIMARY_SALESREP_ID xxx1001xxx
PRINTING_OPTION xxxxxx
TAX_CODE xxxIVA 15%xxx
SET_OF_BOOKS_ID xxx1xxx
CREDIT_METHOD_FOR_ACCT_RULE xxxxxx
CREDIT_METHOD_FOR_INSTALLMENTS xxxxxx
ACCOUNTING_RULE_DURATION xxxxxx
TAX_EXEMPT_FLAG xxxSxxx
TAX_EXEMPT_REASON_CODE xxxxxx

========== 2125061 ==========
CUST_TRX_TYPE_ID xxx1020xxx
INVOICING_RULE_ID xxxxxx
TERM_ID xxx1022xxx
UOM_CODE xxxEAxxx
AGREEMENT_ID xxxxxx
FOB_POINT xxxxxx
SHIP_VIA xxxMario Gonzalezxxx
ACCOUNTING_RULE_ID xxxxxx
MEMO_LINE_ID xxxxxx
RECEIPT_METHOD_ID xxxxxx
LINE_TYPE xxxLINExxx
CONVERSION_TYPE xxx1000xxx
PRIMARY_SALESREP_ID xxx1001xxx
PRINTING_OPTION xxxxxx
TAX_CODE xxxIVA 15%xxx
SET_OF_BOOKS_ID xxx1xxx
CREDIT_METHOD_FOR_ACCT_RULE xxxxxx
CREDIT_METHOD_FOR_INSTALLMENTS xxxxxx
ACCOUNTING_RULE_DURATION xxxxxx
TAX_EXEMPT_FLAG xxxSxxx
TAX_EXEMPT_REASON_CODE xxxxxx

========== 2125062 ==========
CUST_TRX_TYPE_ID xxx1020xxx
INVOICING_RULE_ID xxxxxx
TERM_ID xxx1022xxx
UOM_CODE xxxEAxxx
AGREEMENT_ID xxxxxx
FOB_POINT xxxxxx
SHIP_VIA xxxMario Gonzalezxxx
ACCOUNTING_RULE_ID xxxxxx
MEMO_LINE_ID xxxxxx
RECEIPT_METHOD_ID xxxxxx
LINE_TYPE xxxLINExxx
CONVERSION_TYPE xxx1000xxx
PRIMARY_SALESREP_ID xxx1001xxx
PRINTING_OPTION xxxxxx
TAX_CODE xxxIVA 15%xxx
SET_OF_BOOKS_ID xxx1xxx
CREDIT_METHOD_FOR_ACCT_RULE xxxxxx
CREDIT_METHOD_FOR_INSTALLMENTS xxxxxx
ACCOUNTING_RULE_DURATION xxxxxx
TAX_EXEMPT_FLAG xxxSxxx
TAX_EXEMPT_REASON_CODE xxxxxx

========== 2125063 ==========
CUST_TRX_TYPE_ID xxx1020xxx
INVOICING_RULE_ID xxxxxx
TERM_ID xxx1022xxx
UOM_CODE xxxEAxxx
AGREEMENT_ID xxxxxx
FOB_POINT xxxxxx
SHIP_VIA xxxJUPECSA,S.A DE C.V.xxx
ACCOUNTING_RULE_ID xxxxxx
MEMO_LINE_ID xxxxxx
RECEIPT_METHOD_ID xxxxxx
LINE_TYPE xxxLINExxx
CONVERSION_TYPE xxx1000xxx
PRIMARY_SALESREP_ID xxx1001xxx
PRINTING_OPTION xxxxxx
TAX_CODE xxxIVA 15%xxx
SET_OF_BOOKS_ID xxx1xxx
CREDIT_METHOD_FOR_ACCT_RULE xxxxxx
CREDIT_METHOD_FOR_INSTALLMENTS xxxxxx
ACCOUNTING_RULE_DURATION xxxxxx
TAX_EXEMPT_FLAG xxxSxxx
TAX_EXEMPT_REASON_CODE xxxxxx

raavar()- Current system time is 24-AUG-2004 08:22:57
raajfd()+ Current system time is 24-AUG-2004 08:22:57
INSERT INTO RA_INTERFACE_ERRORS
(INTERFACE_LINE_ID,
MESSAGE_TEXT,
INVALID_VALUE)
SELECT INTERFACE_LINE_ID,
'APP-11871 Invalid reason code (REASON_CODE)',
REASON_CODE
FROM RA_INTERFACE_LINES L
WHERE REQUEST_ID = 6263058
AND REASON_CODE IS NOT NULL
AND NOT EXISTS
(SELECT REPLACE(T.LOOKUP_CODE, '''', '''''')
FROM AR_LOOKUPS T,
RA_CUST_TRX_TYPES TYPE
WHERE L.CUST_TRX_TYPE_ID = TYPE.CUST_TRX_TYPE_ID(+)
AND T.LOOKUP_TYPE = DECODE(TYPE.TYPE, 'CM', 'CREDIT_MEMO_REASON',
'INVOICING_REASON')
AND T.LOOKUP_CODE = L.REASON_CODE)

INSERT INTO RA_INTERFACE_ERRORS
(INTERFACE_LINE_ID,
MESSAGE_TEXT,
INVALID_VALUE)
SELECT INTERFACE_LINE_ID,
'APP-11920 Invalid customer bank account id (CUSTOMER_BANK_ACCOUNT_ID)',
CUSTOMER_BANK_ACCOUNT_ID
FROM RA_INTERFACE_LINES L
WHERE REQUEST_ID = 6263058
AND CUSTOMER_BANK_ACCOUNT_ID IS NOT NULL
AND NOT EXISTS
(SELECT T.BANK_ACCOUNT_ID, T.BANK_ACCOUNT_ID FROM AP_BANK_ACCOUNTS T
WHERE T.BANK_ACCOUNT_ID = L.CUSTOMER_BANK_ACCOUNT_ID)

INSERT INTO RA_INTERFACE_ERRORS
(INTERFACE_LINE_ID,
MESSAGE_TEXT,
INVALID_VALUE)
SELECT INTERFACE_LINE_ID,
'APP-11891 Invalid currency code (CURRENCY_CODE)',
DECODE(CURRENCY_CODE, NULL, '(Nil)', CURRENCY_CODE)
FROM RA_INTERFACE_LINES L
WHERE REQUEST_ID = 6263058
AND NOT EXISTS
(SELECT REPLACE(T.CURRENCY_CODE, '''', ''''''),
REPLACE(T.CURRENCY_CODE, '''', '''''') FROM FND_CURRENCIES T
WHERE T.CURRENCY_CODE = L.CURRENCY_CODE)

raajfd()- Current system time is 24-AUG-2004 08:22:57
raavdx()+ Current system time is 24-AUG-2004 08:22:57
raavdx()- Current system time is 24-AUG-2004 08:22:57
raadld()+ Current system time is 24-AUG-2004 08:22:57
raadld()- Current system time is 24-AUG-2004 08:22:57
raavif()+ Current system time is 24-AUG-2004 08:22:57
raaacp()+ Current system time is 24-AUG-2004 08:22:57
raagsd()+ Current system time is 24-AUG-2004 08:22:57
raagsd()- Current system time is 24-AUG-2004 08:22:57
raaacp()- Current system time is 24-AUG-2004 08:22:57
raabss2()+ Current system time is 24-AUG-2004 08:22:57
SELECT
int.rowid,
int.interface_line_id,
null,
null,
int.inventory_item_id,
combo.INVENTORY_ITEM_ID,
combo.enabled_flag,
nvl(to_number(to_char(combo.start_date_active, 'J')), -1),
nvl(to_number(to_char(combo.end_date_active, 'J')), -1)
,invoice_enabled_flag
FROM
MTL_SYSTEM_ITEMS combo,
ra_interface_lines int
WHERE int.request_id = 6263058
and int.inventory_item_id = combo.INVENTORY_ITEM_ID (+)
and combo_ORGANIZATION_ID (+) = 104
ORDER BY int.inventory_item_id ASC

raabss2()- Current system time is 24-AUG-2004 08:22:57
raaamd()+ Current system time is 24-AUG-2004 08:22:57
raaamd()- Current system time is 24-AUG-2004 08:22:57
raaasp()+ Current system time is 24-AUG-2004 08:22:57
raaasp()- Current system time is 24-AUG-2004 08:22:57
raaamc()+ Current system time is 24-AUG-2004 08:22:57
raaamc()- Current system time is 24-AUG-2004 08:22:57
raavui2()+ Current system time is 24-AUG-2004 08:22:57
raavui2()- Current system time is 24-AUG-2004 08:22:57
raaffm()+ Current system time is 24-AUG-2004 08:22:57
raaffm()- Current system time is 24-AUG-2004 08:22:57
raavif()- Current system time is 24-AUG-2004 08:22:57
raavli()+ Current system time is 24-AUG-2004 08:22:57
raavli()- Current system time is 24-AUG-2004 08:22:57
raavci()+ Current system time is 24-AUG-2004 08:22:57
raavci()- Current system time is 24-AUG-2004 08:22:57
raavdf()+ Current system time is 24-AUG-2004 08:22:57
INSERT INTO RA_INTERFACE_ERRORS
(INTERFACE_LINE_ID,
MESSAGE_TEXT,
INVALID_VALUE)
SELECT
INTERFACE_LINE_ID,
'APP-11913 All enabled segments of Transaction Flexfield must have a value',
INTERFACE_LINE_ATTRIBUTE1||'.'||INTERFACE_LINE_ATTRIBUTE2||'.'||INTERFACE_LINE_ATTRIBUTE3||'.'||INTERFACE_LINE_ATTRIBUTE4||'.'||INTERFACE_LINE_ATTRIBUTE5||'.'||INTERFACE_LINE_ATTRIBUTE6||'.'||INTERFACE_LINE_ATTRIBUTE7
FROM RA_INTERFACE_LINES
WHERE REQUEST_ID = 6263058
AND INTERFACE_LINE_CONTEXT = 'ORDER ENTRY'
AND
(
INTERFACE_LINE_ATTRIBUTE1 IS NULL
OR INTERFACE_LINE_ATTRIBUTE2 IS NULL
OR INTERFACE_LINE_ATTRIBUTE3 IS NULL
OR INTERFACE_LINE_ATTRIBUTE4 IS NULL
OR INTERFACE_LINE_ATTRIBUTE5 IS NULL
OR INTERFACE_LINE_ATTRIBUTE6 IS NULL
OR INTERFACE_LINE_ATTRIBUTE7 IS NULL
)

len = 776

INSERT INTO RA_INTERFACE_ERRORS
(INTERFACE_LINE_ID,
MESSAGE_TEXT,
INVALID_VALUE)
SELECT
INTERFACE_LINE_ID,
'APP-11914 Duplicate Transaction Flexfield',
INTERFACE_LINE_ATTRIBUTE1||'.'||INTERFACE_LINE_ATTRIBUTE2||'.'||INTERFACE_LINE_ATTRIBUTE3||'.'||INTERFACE_LINE_ATTRIBUTE4||'.'||INTERFACE_LINE_ATTRIBUTE5||'.'||INTERFACE_LINE_ATTRIBUTE6||'.'||INTERFACE_LINE_ATTRIBUTE7
FROM RA_INTERFACE_LINES IL
WHERE IL.REQUEST_ID = 6263058
AND IL.INTERFACE_LINE_CONTEXT = 'ORDER ENTRY'
AND (EXISTS
(SELECT 'X'
FROM RA_CUSTOMER_TRX_LINES TL
WHERE IL.INTERFACE_LINE_CONTEXT = TL.INTERFACE_LINE_CONTEXT
AND IL.INTERFACE_LINE_ATTRIBUTE1 = TL.INTERFACE_LINE_ATTRIBUTE1
AND IL.INTERFACE_LINE_ATTRIBUTE2 = TL.INTERFACE_LINE_ATTRIBUTE2
AND IL.INTERFACE_LINE_ATTRIBUTE3 = TL.INTERFACE_LINE_ATTRIBUTE3
AND IL.INTERFACE_LINE_ATTRIBUTE4 = TL.INTERFACE_LINE_ATTRIBUTE4
AND IL.INTERFACE_LINE_ATTRIBUTE5 = TL.INTERFACE_LINE_ATTRIBUTE5
AND IL.INTERFACE_LINE_ATTRIBUTE6 = TL.INTERFACE_LINE_ATTRIBUTE6
AND IL.INTERFACE_LINE_ATTRIBUTE7 = TL.INTERFACE_LINE_ATTRIBUTE7
)
OR EXISTS
(SELECT 'X'
FROM RA_INTERFACE_LINES L
WHERE L.ROWID != IL.ROWID
AND L.INTERFACE_LINE_CONTEXT = IL.INTERFACE_LINE_CONTEXT
AND L.INTERFACE_LINE_ATTRIBUTE1 = IL.INTERFACE_LINE_ATTRIBUTE1
AND L.INTERFACE_LINE_ATTRIBUTE2 = IL.INTERFACE_LINE_ATTRIBUTE2
AND L.INTERFACE_LINE_ATTRIBUTE3 = IL.INTERFACE_LINE_ATTRIBUTE3
AND L.INTERFACE_LINE_ATTRIBUTE4 = IL.INTERFACE_LINE_ATTRIBUTE4
AND L.INTERFACE_LINE_ATTRIBUTE5 = IL.INTERFACE_LINE_ATTRIBUTE5
AND L.INTERFACE_LINE_ATTRIBUTE6 = IL.INTERFACE_LINE_ATTRIBUTE6
AND L.INTERFACE_LINE_ATTRIBUTE7 = IL.INTERFACE_LINE_ATTRIBUTE7
))

len = 1797

INSERT INTO RA_INTERFACE_ERRORS
(INTERFACE_LINE_ID,
MESSAGE_TEXT,
INVALID_VALUE)
SELECT
INTERFACE_LINE_ID,
'APP-11911 Invalid reference line attribute value (REFERENCE_LINE_ATTRIBUTE1-15)',
REFERENCE_LINE_ATTRIBUTE1||'.'||REFERENCE_LINE_ATTRIBUTE2||'.'||REFERENCE_LINE_ATTRIBUTE3||'.'||REFERENCE_LINE_ATTRIBUTE4||'.'||REFERENCE_LINE_ATTRIBUTE5||'.'||REFERENCE_LINE_ATTRIBUTE6||'.'||REFERENCE_LINE_ATTRIBUTE7
FROM RA_INTERFACE_LINES INT_LINE
WHERE INT_LINE.REQUEST_ID = 6263058
AND INT_LINE.REFERENCE_LINE_ID IS NULL
AND INT_LINE.REFERENCE_LINE_CONTEXT = 'ORDER ENTRY'
AND ( INT_LINE.REFERENCE_LINE_ATTRIBUTE1 IS NOT NULL
OR INT_LINE.REFERENCE_LINE_ATTRIBUTE2 IS NOT NULL
OR INT_LINE.REFERENCE_LINE_ATTRIBUTE3 IS NOT NULL
OR INT_LINE.REFERENCE_LINE_ATTRIBUTE4 IS NOT NULL
OR INT_LINE.REFERENCE_LINE_ATTRIBUTE5 IS NOT NULL
OR INT_LINE.REFERENCE_LINE_ATTRIBUTE6 IS NOT NULL
OR INT_LINE.REFERENCE_LINE_ATTRIBUTE7 IS NOT NULL
)
AND (NOT EXISTS
(SELECT 'X'
FROM RA_CUSTOMER_TRX_LINES LINE
WHERE INT_LINE.REFERENCE_LINE_CONTEXT =
LINE.INTERFACE_LINE_CONTEXT
AND INT_LINE.REFERENCE_LINE_ATTRIBUTE1 = LINE.INTERFACE_LINE_ATTRIBUTE1
AND INT_LINE.REFERENCE_LINE_ATTRIBUTE2 = LINE.INTERFACE_LINE_ATTRIBUTE2
AND INT_LINE.REFERENCE_LINE_ATTRIBUTE3 = LINE.INTERFACE_LINE_ATTRIBUTE3
AND INT_LINE.REFERENCE_LINE_ATTRIBUTE4 = LINE.INTERFACE_LINE_ATTRIBUTE4
AND INT_LINE.REFERENCE_LINE_ATTRIBUTE5 = LINE.INTERFACE_LINE_ATTRIBUTE5
AND INT_LINE.REFERENCE_LINE_ATTRIBUTE6 = LINE.INTERFACE_LINE_ATTRIBUTE6
AND INT_LINE.REFERENCE_LINE_ATTRIBUTE7 = LINE.INTERFACE_LINE_ATTRIBUTE7
)
AND NOT EXISTS
(SELECT 'X'
FROM RA_INTERFACE_LINES LINE
WHERE INT_LINE.REFERENCE_LINE_CONTEXT =
LINE.INTERFACE_LINE_CONTEXT
AND INT_LINE.REFERENCE_LINE_ATTRIBUTE1 = LINE.INTERFACE_LINE_ATTRIBUTE1
AND INT_LINE.REFERENCE_LINE_ATTRIBUTE2 = LINE.INTERFACE_LINE_ATTRIBUTE2
AND INT_LINE.REFERENCE_LINE_ATTRIBUTE3 = LINE.INTERFACE_LINE_ATTRIBUTE3
AND INT_LINE.REFERENCE_LINE_ATTRIBUTE4 = LINE.INTERFACE_LINE_ATTRIBUTE4
AND INT_LINE.REFERENCE_LINE_ATTRIBUTE5 = LINE.INTERFACE_LINE_ATTRIBUTE5
AND INT_LINE.REFERENCE_LINE_ATTRIBUTE6 = LINE.INTERFACE_LINE_ATTRIBUTE6
AND INT_LINE.REFERENCE_LINE_ATTRIBUTE7 = LINE.INTERFACE_LINE_ATTRIBUTE7
)
)

len = 2419

INSERT INTO RA_INTERFACE_ERRORS
(INTERFACE_LINE_ID,
MESSAGE_TEXT,
INVALID_VALUE)
SELECT
INTERFACE_LINE_ID,
DECODE(INT_TRX_TYPE.TYPE,
'CM', 'APP-11966 An invoice can only reference a commitment',
'DM', 'APP-11966 An invoice can only reference a commitment',
'INV', 'APP-11966 An invoice can only reference a commitment'),
REFERENCE_LINE_ATTRIBUTE1||'.'||REFERENCE_LINE_ATTRIBUTE2||'.'||REFERENCE_LINE_ATTRIBUTE3||'.'||REFERENCE_LINE_ATTRIBUTE4||'.'||REFERENCE_LINE_ATTRIBUTE5||'.'||REFERENCE_LINE_ATTRIBUTE6||'.'||REFERENCE_LINE_ATTRIBUTE7
FROM RA_CUST_TRX_TYPES INT_TRX_TYPE,
RA_INTERFACE_LINES INT_LINE
WHERE INT_LINE.REQUEST_ID = 6263058
AND INT_LINE.CUST_TRX_TYPE_ID =
INT_TRX_TYPE.CUST_TRX_TYPE_ID
AND INT_LINE.REFERENCE_LINE_ID IS NULL
AND INT_LINE.REFERENCE_LINE_CONTEXT = 'ORDER ENTRY'
AND ( INT_LINE.REFERENCE_LINE_ATTRIBUTE1 IS NOT NULL
OR INT_LINE.REFERENCE_LINE_ATTRIBUTE2 IS NOT NULL
OR INT_LINE.REFERENCE_LINE_ATTRIBUTE3 IS NOT NULL
OR INT_LINE.REFERENCE_LINE_ATTRIBUTE4 IS NOT NULL
OR INT_LINE.REFERENCE_LINE_ATTRIBUTE5 IS NOT NULL
OR INT_LINE.REFERENCE_LINE_ATTRIBUTE6 IS NOT NULL
OR INT_LINE.REFERENCE_LINE_ATTRIBUTE7 IS NOT NULL
)
AND (NOT EXISTS
(SELECT 'X'
FROM RA_CUSTOMER_TRX_LINES LINE,
RA_CUSTOMER_TRX TRX,
RA_CUST_TRX_TYPES TRX_TYPE
WHERE INT_LINE.REFERENCE_LINE_CONTEXT =
LINE.INTERFACE_LINE_CONTEXT
AND INT_LINE.REFERENCE_LINE_ATTRIBUTE1 = LINE.INTERFACE_LINE_ATTRIBUTE1
AND INT_LINE.REFERENCE_LINE_ATTRIBUTE2 = LINE.INTERFACE_LINE_ATTRIBUTE2
AND INT_LINE.REFERENCE_LINE_ATTRIBUTE3 = LINE.INTERFACE_LINE_ATTRIBUTE3
AND INT_LINE.REFERENCE_LINE_ATTRIBUTE4 = LINE.INTERFACE_LINE_ATTRIBUTE4
AND INT_LINE.REFERENCE_LINE_ATTRIBUTE5 = LINE.INTERFACE_LINE_ATTRIBUTE5
AND INT_LINE.REFERENCE_LINE_ATTRIBUTE6 = LINE.INTERFACE_LINE_ATTRIBUTE6
AND INT_LINE.REFERENCE_LINE_ATTRIBUTE7 = LINE.INTERFACE_LINE_ATTRIBUTE7
AND LINE.CUSTOMER_TRX_ID = TRX.CUSTOMER_TRX_ID
AND TRX.CUST_TRX_TYPE_ID = TRX_TYPE.CUST_TRX_TYPE_ID
AND INT_TRX_TYPE.TYPE =
DECODE(TRX_TYPE.TYPE,
'DEP', 'INV',
'GUAR', 'INV',
'INV', 'CM',
'DM', 'CM',
'~!'))
AND NOT EXISTS
(SELECT 'X'
FROM RA_INTERFACE_LINES LINE,
RA_CUST_TRX_TYPES TRX_TYPE
WHERE INT_LINE.REFERENCE_LINE_CONTEXT =
LINE.INTERFACE_LINE_CONTEXT
AND INT_LINE.REFERENCE_LINE_ATTRIBUTE1 = LINE.INTERFACE_LINE_ATTRIBUTE1
AND INT_LINE.REFERENCE_LINE_ATTRIBUTE2 = LINE.INTERFACE_LINE_ATTRIBUTE2
AND INT_LINE.REFERENCE_LINE_ATTRIBUTE3 = LINE.INTERFACE_LINE_ATTRIBUTE3
AND INT_LINE.REFERENCE_LINE_ATTRIBUTE4 = LINE.INTERFACE_LINE_ATTRIBUTE4
AND INT_LINE.REFERENCE_LINE_ATTRIBUTE5 = LINE.INTERFACE_LINE_ATTRIBUTE5
AND INT_LINE.REFERENCE_LINE_ATTRIBUTE6 = LINE.INTERFACE_LINE_ATTRIBUTE6
AND INT_LINE.REFERENCE_LINE_ATTRIBUTE7 = LINE.INTERFACE_LINE_ATTRIBUTE7
AND INT_TRX_TYPE.TYPE =
DECODE(TRX_TYPE.TYPE,
'DEP', 'INV',
'GUAR', 'INV',
'INV', 'CM',
'DM', 'CM',
'~!'))
)

len = 3420

raavdf()- Current system time is 24-AUG-2004 08:22:57
raavtf()+ Current system time is 24-AUG-2004 08:22:57
raaacp()+ Current system time is 24-AUG-2004 08:22:57
raagsd()+ Current system time is 24-AUG-2004 08:22:57
raagsd()- Current system time is 24-AUG-2004 08:22:57
raaacp()- Current system time is 24-AUG-2004 08:22:57
raabss2()+ Current system time is 24-AUG-2004 08:22:57
SELECT
int.rowid,
int.interface_line_id,
null,
null,
int.territory_id,
combo.TERRITORY_ID,
combo.enabled_flag,
nvl(to_number(to_char(combo.start_date_active, 'J')), -1),
nvl(to_number(to_char(combo.end_date_active, 'J')), -1)
FROM
RA_TERRITORIES combo,
ra_interface_lines int
WHERE int.request_id = 6263058
and int.territory_id = combo.TERRITORY_ID (+)
ORDER BY int.territory_id ASC

raabss2()- Current system time is 24-AUG-2004 08:22:57
raaamd()+ Current system time is 24-AUG-2004 08:22:57
raaamd()- Current system time is 24-AUG-2004 08:22:57
raaasp()+ Current system time is 24-AUG-2004 08:22:57
raaasp()- Current system time is 24-AUG-2004 08:22:57
raaamc()+ Current system time is 24-AUG-2004 08:22:57
raaamc()- Current system time is 24-AUG-2004 08:22:57
raavui2()+ Current system time is 24-AUG-2004 08:22:58
raavui2()- Current system time is 24-AUG-2004 08:22:58
raaffm()+ Current system time is 24-AUG-2004 08:22:58
raaffm()- Current system time is 24-AUG-2004 08:22:58
raavtf()- Current system time is 24-AUG-2004 08:22:58
raavtc()+ Current system time is 24-AUG-2004 08:22:58
raavtc()- Current system time is 24-AUG-2004 08:22:58
raavcx()+ Current system time is 24-AUG-2004 08:22:58
raavcx()- Current system time is 24-AUG-2004 08:22:58
raapu0()- Current system time is 24-AUG-2004 08:22:58
raapu1()+ Current system time is 24-AUG-2004 08:22:58
raavsi()+ Current system time is 24-AUG-2004 08:22:58
raavsi()- Current system time is 24-AUG-2004 08:22:58
raapu1()- Current system time is 24-AUG-2004 08:22:58
raapu2()+ Current system time is 24-AUG-2004 08:22:58
raavaf()+ Current system time is 24-AUG-2004 08:22:58
raaacp()+ Current system time is 24-AUG-2004 08:22:58
raagsd()+ Current system time is 24-AUG-2004 08:22:58
raagsd()- Current system time is 24-AUG-2004 08:22:58
raaacp()- Current system time is 24-AUG-2004 08:22:58
raabss2()+ Current system time is 24-AUG-2004 08:22:58
SELECT
int.rowid,
int.interface_line_id,
null,
int.interface_distribution_id,
int.code_combination_id,
combo.CODE_COMBINATION_ID,
combo.enabled_flag,
nvl(to_number(to_char(combo.start_date_active, 'J')), -1),
nvl(to_number(to_char(combo.end_date_active, 'J')), -1)
,detail_posting_allowed_flag,summary_flag
FROM
GL_CODE_COMBINATIONS combo,
ra_interface_distributions int
WHERE int.request_id = 6263058
and int.code_combination_id = combo.CODE_COMBINATION_ID (+)
and combo.CHART_OF_ACCOUNTS_ID (+) = 50133
ORDER BY int.code_combination_id ASC

raabss2()- Current system time is 24-AUG-2004 08:22:58
raaamd()+ Current system time is 24-AUG-2004 08:22:58
raaamd()- Current system time is 24-AUG-2004 08:22:58
raaasp()+ Current system time is 24-AUG-2004 08:22:58
raaasp()- Current system time is 24-AUG-2004 08:22:58
raaamc()+ Current system time is 24-AUG-2004 08:22:58
raaamc()- Current system time is 24-AUG-2004 08:22:58
raaffm()+ Current system time is 24-AUG-2004 08:22:58
raaffm()- Current system time is 24-AUG-2004 08:22:58
raavaf()- Current system time is 24-AUG-2004 08:22:58
raavdi()+ Current system time is 24-AUG-2004 08:22:58
raavdi()- Current system time is 24-AUG-2004 08:22:58
raapu2()- Current system time is 24-AUG-2004 08:22:58
raagtc()+ Current system time is 24-AUG-2004 08:22:58
SELECT DECODE(TYPE.TYPE, 'INV', 0, 'DM', 1, 'CM', 2),
DECODE(L.REFERENCE_LINE_ID,
NULL, DECODE(L.REFERENCE_LINE_ATTRIBUTE1
|| L.REFERENCE_LINE_ATTRIBUTE2
|| L.REFERENCE_LINE_ATTRIBUTE3
|| L.REFERENCE_LINE_ATTRIBUTE4
|| L.REFERENCE_LINE_ATTRIBUTE5
|| L.REFERENCE_LINE_ATTRIBUTE6
|| L.REFERENCE_LINE_ATTRIBUTE7
|| L.REFERENCE_LINE_ATTRIBUTE8
|| L.REFERENCE_LINE_ATTRIBUTE9
|| L.REFERENCE_LINE_ATTRIBUTE10
|| L.REFERENCE_LINE_ATTRIBUTE11
|| L.REFERENCE_LINE_ATTRIBUTE12
|| L.REFERENCE_LINE_ATTRIBUTE13
|| L.REFERENCE_LINE_ATTRIBUTE14
|| L.REFERENCE_LINE_ATTRIBUTE15,
NULL, 0,
1),
1),
COUNT(*)
FROM RA_CUST_TRX_TYPES TYPE,
RA_INTERFACE_LINES L
WHERE L.REQUEST_ID = 6263058
AND L.CUST_TRX_TYPE_ID = TYPE.CUST_TRX_TYPE_ID
GROUP BY DECODE(TYPE.TYPE, 'INV', 0, 'DM', 1, 'CM', 2),
DECODE(L.REFERENCE_LINE_ID,
NULL, DECODE(L.REFERENCE_LINE_ATTRIBUTE1
|| L.REFERENCE_LINE_ATTRIBUTE2
|| L.REFERENCE_LINE_ATTRIBUTE3
|| L.REFERENCE_LINE_ATTRIBUTE4
|| L.REFERENCE_LINE_ATTRIBUTE5
|| L.REFERENCE_LINE_ATTRIBUTE6
|| L.REFERENCE_LINE_ATTRIBUTE7
|| L.REFERENCE_LINE_ATTRIBUTE8
|| L.REFERENCE_LINE_ATTRIBUTE9
|| L.REFERENCE_LINE_ATTRIBUTE10
|| L.REFERENCE_LINE_ATTRIBUTE11
|| L.REFERENCE_LINE_ATTRIBUTE12
|| L.REFERENCE_LINE_ATTRIBUTE13
|| L.REFERENCE_LINE_ATTRIBUTE14
|| L.REFERENCE_LINE_ATTRIBUTE15,
NULL, 0,
1),
1)
ORDER BY 1 ASC, 2 DESC

len = 1529

Dumping the contents of struct raagtx ...
raagtxnr = 1
0 gtb->raagtxti = 1
0 gtb->raagtxtc = 8
raagtc()- Current system time is 24-AUG-2004 08:22:58
raaibd()+ Current system time is 24-AUG-2004 08:22:58
raaibd()- Current system time is 24-AUG-2004 08:22:59
raapic()+ Current system time is 24-AUG-2004 08:22:59

Grouping : Current system time is 24-AUG-2004 08:22:59
raagtl()+ Current system time is 24-AUG-2004 08:22:59
SELECT DISTINCT
NVL(BS.GROUPING_RULE_ID,
NVL(P_SITE.GROUPING_RULE_ID,
NVL(P_CUST.GROUPING_RULE_ID,
P.DEFAULT_GROUPING_RULE_ID))),
T.TYPE
FROM AR_SYSTEM_PARAMETERS P,
RA_BATCH_SOURCES BS,
RA_CUST_TRX_TYPES T,
RA_SITE_USES U,
AR_CUSTOMER_PROFILES P_CUST,
AR_CUSTOMER_PROFILES P_SITE,
RA_INTERFACE_LINES L
WHERE L.REQUEST_ID = 6263058
AND NVL(L.INTERFACE_STATUS, '~') != 'P'
AND BS.BATCH_SOURCE_ID = 1088
AND L.ORIG_SYSTEM_BILL_CUSTOMER_ID = P_CUST.CUSTOMER_ID
AND P_CUST.SITE_USE_ID IS NULL
AND L.ORIG_SYSTEM_BILL_ADDRESS_ID = U.ADDRESS_ID(+)
AND U.SITE_USE_CODE(+) = 'BILL_TO'
AND U.STATUS(+) = 'A'
AND U.SITE_USE_ID = P_SITE.SITE_USE_ID (+)
AND L.SET_OF_BOOKS_ID = P.SET_OF_BOOKS_ID
AND L.CUST_TRX_TYPE_ID = T.CUST_TRX_TYPE_ID
AND NOT
((L.REFERENCE_LINE_ID IS NOT NULL
or l.reference_line_attribute1
|| l.reference_line_attribute2
|| l.reference_line_attribute3
|| l.reference_line_attribute4
|| l.reference_line_attribute5
|| l.reference_line_attribute6
|| l.reference_line_attribute7
|| l.reference_line_attribute8
|| l.reference_line_attribute9
|| l.reference_line_attribute10
|| l.reference_line_attribute11
|| l.reference_line_attribute12
|| l.reference_line_attribute13
|| l.reference_line_attribute14
|| l.reference_line_attribute15 is not null)
AND T.TYPE = 'CM')

len = 1421
raauct()+ Current system time is 24-AUG-2004 08:22:59
raaggc()+ Current system time is 24-AUG-2004 08:22:59
raaggc()- Current system time is 24-AUG-2004 08:22:59
raagoc()+ Current system time is 24-AUG-2004 08:22:59
raagoc()- Current system time is 24-AUG-2004 08:22:59
select
L.AGREEMENT_ID||'~'||L.COMMENTS||'~'||L.CONVERSION_RATE||'~'||L.CONVERSION_TYPE||'~'||L.CREDIT_METHOD_FOR_ACCT_RULE||'~'||L.CREDIT_METHOD_FOR_INSTALLMENTS||'~'||L.CURRENCY_CODE||'~'||L.CUSTOMER_BANK_ACCOUNT_ID||'~'||L.CUST_TRX_TYPE_ID||'~'||L.DOCUMENT_NUMBER||'~'||L.DOCUMENT_NUMBER_SEQUENCE_ID||'~'||L.GL_DATE||'~'||L.HEADER_ATTRIBUTE1||'~'||L.HEADER_ATTRIBUTE10||'~'||L.HEADER_ATTRIBUTE11||'~'||L.HEADER_ATTRIBUTE12||'~'||L.HEADER_ATTRIBUTE13||'~'||L.HEADER_ATTRIBUTE14||'~'||L.HEADER_ATTRIBUTE15||'~'||L.HEADER_ATTRIBUTE2||'~'||L.HEADER_ATTRIBUTE3||'~'||L.HEADER_ATTRIBUTE4||'~'||L.HEADER_ATTRIBUTE5||'~'||L.HEADER_ATTRIBUTE6||'~'||L.HEADER_ATTRIBUTE7||'~'||L.HEADER_ATTRIBUTE8||'~'||L.HEADER_ATTRIBUTE9||'~'||L.HEADER_ATTRIBUTE_CATEGORY||'~'||L.INITIAL_CUSTOMER_TRX_ID||'~'||L.INTERFACE_LINE_ATTRIBUTE1||'~'||L.INTERFACE_LINE_ATTRIBUTE2||'~'||L.INTERFACE_LINE_ATTRIBUTE3||'~'||L.INTERFACE_LINE_ATTRIBUTE4||'~'||L.INTERFACE_LINE_CONTEXT||'~'||L.INTERNAL_NOTES||'~'||L.INVOICING_RULE_ID||'~'||L.ORIG_SYSTEM_BATCH_NAME||'~'||L.ORIG_SYSTEM_BILL_ADDRESS_ID||'~'||L.ORIG_SYSTEM_BILL_CONTACT_ID||'~'||L.ORIG_SYSTEM_BILL_CUSTOMER_ID||'~'||L.ORIG_SYSTEM_SHIP_ADDRESS_ID||'~'||L.ORIG_SYSTEM_SHIP_CONTACT_ID||'~'||L.ORIG_SYSTEM_SHIP_CUSTOMER_ID||'~'||L.ORIG_SYSTEM_SOLD_CUSTOMER_ID||'~'||L.PREVIOUS_CUSTOMER_TRX_ID||'~'||L.PRIMARY_SALESREP_ID||'~'||L.PRINTING_OPTION||'~'||L.PURCHASE_ORDER||'~'||L.PURCHASE_ORDER_DATE||'~'||L.PURCHASE_ORDER_REVISION||'~'||L.REASON_CODE||'~'||L.RECEIPT_METHOD_ID||'~'||L.RELATED_CUSTOMER_TRX_ID||'~'||L.SET_OF_BOOKS_ID||'~'||L.TERM_ID||'~'||L.TERRITORY_ID||'~'||L.TRX_DATE||'~'||L.TRX_NUMBER||'~'||NVL(L.CONVERSION_DATE, L.TRX_DATE),
substrb(l.line_type,1,1),
l.ORG_ID,
l.INTERFACE_LINE_CONTEXT,
l.INTERFACE_LINE_ATTRIBUTE1,
l.INTERFACE_LINE_ATTRIBUTE2,
l.INTERFACE_LINE_ATTRIBUTE3,
l.INTERFACE_LINE_ATTRIBUTE4,
l.INTERFACE_LINE_ATTRIBUTE6,
l.INTERFACE_LINE_ATTRIBUTE7,
null,
null,
l.rowid,
null,
'B',
2
from ra_cust_trx_types t,
ra_interface_lines l
where l.request_id = 6263058
and nvl(l.interface_status, '~') != 'P'
and l.cust_trx_type_id = t.cust_trx_type_id
and t.type = 'INV'
and NOT
((l.reference_line_id is not null
or l.reference_line_attribute1
|| l.reference_line_attribute2
|| l.reference_line_attribute3
|| l.reference_line_attribute4
|| l.reference_line_attribute5
|| l.reference_line_attribute6
|| l.reference_line_attribute7
|| l.reference_line_attribute8
|| l.reference_line_attribute9
|| l.reference_line_attribute10
|| l.reference_line_attribute11
|| l.reference_line_attribute12
|| l.reference_line_attribute13
|| l.reference_line_attribute14
|| l.reference_line_attribute15 is not null)
and t.type = 'CM')
and exists
(
select 'x'
from ra_interface_lines l2,
ra_site_uses u,
ar_customer_profiles p_cust,
ar_customer_profiles p_site,
ra_batch_sources bs,
ar_system_parameters p
where l2.orig_system_bill_customer_id = p_cust.customer_id
and p_cust.site_use_id is null
and l2.orig_system_bill_address_id = u.address_id(+)
and u.site_use_code(+) = 'BILL_TO'
and u.status(+) = 'A'
and u.site_use_id = p_site.site_use_id (+)
and nvl(bs.grouping_rule_id,
nvl(p_site.grouping_rule_id,
nvl(p_cust.grouping_rule_id,
p.default_grouping_rule_id)))
= 1040
and l2.set_of_books_id = p.set_of_books_id
and l.rowid = l2.rowid
and bs.batch_source_id = 1088
)
and nvl(l.interface_status, '~') != 'P'
and l.link_to_line_id is null
and not exists
(
select 'x'
from ra_interface_errors e
where e.interface_line_id = l.interface_line_id
)
and not exists
(
select 'x'
from ra_interface_lines lk
where exists
(select 'x'
from ra_interface_errors e
where e.interface_line_id = lk.interface_line_id)
and lk.link_to_line_id = l.interface_line_id
)
union
select
L.AGREEMENT_ID||'~'||L.COMMENTS||'~'||L.CONVERSION_RATE||'~'||L.CONVERSION_TYPE||'~'||L.CREDIT_METHOD_FOR_ACCT_RULE||'~'||L.CREDIT_METHOD_FOR_INSTALLMENTS||'~'||L.CURRENCY_CODE||'~'||L.CUSTOMER_BANK_ACCOUNT_ID||'~'||L.CUST_TRX_TYPE_ID||'~'||L.DOCUMENT_NUMBER||'~'||L.DOCUMENT_NUMBER_SEQUENCE_ID||'~'||L.GL_DATE||'~'||L.HEADER_ATTRIBUTE1||'~'||L.HEADER_ATTRIBUTE10||'~'||L.HEADER_ATTRIBUTE11||'~'||L.HEADER_ATTRIBUTE12||'~'||L.HEADER_ATTRIBUTE13||'~'||L.HEADER_ATTRIBUTE14||'~'||L.HEADER_ATTRIBUTE15||'~'||L.HEADER_ATTRIBUTE2||'~'||L.HEADER_ATTRIBUTE3||'~'||L.HEADER_ATTRIBUTE4||'~'||L.HEADER_ATTRIBUTE5||'~'||L.HEADER_ATTRIBUTE6||'~'||L.HEADER_ATTRIBUTE7||'~'||L.HEADER_ATTRIBUTE8||'~'||L.HEADER_ATTRIBUTE9||'~'||L.HEADER_ATTRIBUTE_CATEGORY||'~'||L.INITIAL_CUSTOMER_TRX_ID||'~'||L.INTERFACE_LINE_ATTRIBUTE1||'~'||L.INTERFACE_LINE_ATTRIBUTE2||'~'||L.INTERFACE_LINE_ATTRIBUTE3||'~'||L.INTERFACE_LINE_ATTRIBUTE4||'~'||L.INTERFACE_LINE_CONTEXT||'~'||L.INTERNAL_NOTES||'~'||L.INVOICING_RULE_ID||'~'||L.ORIG_SYSTEM_BATCH_NAME||'~'||L.ORIG_SYSTEM_BILL_ADDRESS_ID||'~'||L.ORIG_SYSTEM_BILL_CONTACT_ID||'~'||L.ORIG_SYSTEM_BILL_CUSTOMER_ID||'~'||L.ORIG_SYSTEM_SHIP_ADDRESS_ID||'~'||L.ORIG_SYSTEM_SHIP_CONTACT_ID||'~'||L.ORIG_SYSTEM_SHIP_CUSTOMER_ID||'~'||L.ORIG_SYSTEM_SOLD_CUSTOMER_ID||'~'||L.PREVIOUS_CUSTOMER_TRX_ID||'~'||L.PRIMARY_SALESREP_ID||'~'||L.PRINTING_OPTION||'~'||L.PURCHASE_ORDER||'~'||L.PURCHASE_ORDER_DATE||'~'||L.PURCHASE_ORDER_REVISION||'~'||L.REASON_CODE||'~'||L.RECEIPT_METHOD_ID||'~'||L.RELATED_CUSTOMER_TRX_ID||'~'||L.SET_OF_BOOKS_ID||'~'||L.TERM_ID||'~'||L.TERRITORY_ID||'~'||L.TRX_DATE||'~'||L.TRX_NUMBER||'~'||NVL(L.CONVERSION_DATE, L.TRX_DATE),
substrb(l.line_type,1,1),
l.ORG_ID,
l.INTERFACE_LINE_CONTEXT,
l.INTERFACE_LINE_ATTRIBUTE1,
l.INTERFACE_LINE_ATTRIBUTE2,
l.INTERFACE_LINE_ATTRIBUTE3,
l.INTERFACE_LINE_ATTRIBUTE4,
l.INTERFACE_LINE_ATTRIBUTE6,
l.INTERFACE_LINE_ATTRIBUTE7,
null,
null,
l.rowid,
null,
'B',
1
from ra_cust_trx_types t,
ra_interface_lines l
where l.request_id = 6263058
and nvl(l.interface_status, '~') != 'P'
and l.cust_trx_type_id = t.cust_trx_type_id
and t.type = 'INV'
and NOT
((l.reference_line_id is not null
or l.reference_line_attribute1
|| l.reference_line_attribute2
|| l.reference_line_attribute3
|| l.reference_line_attribute4
|| l.reference_line_attribute5
|| l.reference_line_attribute6
|| l.reference_line_attribute7
|| l.reference_line_attribute8
|| l.reference_line_attribute9
|| l.reference_line_attribute10
|| l.reference_line_attribute11
|| l.reference_line_attribute12
|| l.reference_line_attribute13
|| l.reference_line_attribute14
|| l.reference_line_attribute15 is not null)
and t.type = 'CM')
and exists
(
select 'x'
from ra_interface_lines l2,
ra_site_uses u,
ar_customer_profiles p_cust,
ar_customer_profiles p_site,
ra_batch_sources bs,
ar_system_parameters p
where l2.orig_system_bill_customer_id = p_cust.customer_id
and p_cust.site_use_id is null
and l2.orig_system_bill_address_id = u.address_id(+)
and u.site_use_code(+) = 'BILL_TO'
and u.status(+) = 'A'
and u.site_use_id = p_site.site_use_id (+)
and nvl(bs.grouping_rule_id,
nvl(p_site.grouping_rule_id,
nvl(p_cust.grouping_rule_id,
p.default_grouping_rule_id)))
= 1040
and l2.set_of_books_id = p.set_of_books_id
and l.rowid = l2.rowid
and bs.batch_source_id = 1088
)
and nvl(l.interface_status, '~') != 'P'
and l.link_to_line_id is null
and (exists
(
select 'x
 
Sort by date Sort by votes
J,

I don't know if you noticed, but your thread post was so long that it truncated your posting. We cannot see your error message. Please post just the error message and hopefully, we will be able to suggest some help. Usually, Tek-Tips members are not thrilled about having to read 100s of lines of code, so if there is a way to trim down your post to just the essential pieces, we are more likely to respond.

Hoping to help,

[santa]Mufasa
(aka Dave of Sandy, Utah, USA @ 18:41 (24Aug04) UTC (aka "GMT" and "Zulu"), 11:41 (24Aug04) Mountain Time)
 
Upvote 0 Downvote
ORA-01427: single-row subquery returns more than one row

Previous Messages (for Support Purposes)
Dumping data fetched from RA_BATCH_SOURCES
len = 1108
8 rows updated
len = 1651
0 rows updated

update RA_CUSTOMER_TRX T set BILL_TO_SITE_USE_ID=(select SITE_USE_ID

raadhd.lpc 760
APP-11813 Error calling raadhd()
APP-11813 Error calling raapic()
raacit()+ Current system time is 24-AUG-2004 18:37:00
8 row(s) updated Current system time is 24-AUG-2004 18:37:00
0 row(s) deleted Current system time is 24-AUG-2004 18:37:00
0 row(s) deleted Current system time is 24-AUG-2004 18:37:00
0 row(s) deleted Current system time is 24-AUG-2004 18:37:00
raadcr()+ Current system time is 24-AUG-2004 18:37:00
raadcr()- Current system time is 24-AUG-2004 18:37:00
raacit()- Current system time is 24-AUG-2004 18:37:00
raafds()+ Current system time is 24-AUG-2004 18:37:00
raafeb()+ Current system time is 24-AUG-2004 18:37:00
raafeb()- Current system time is 24-AUG-2004 18:37:00
arcdcu()+ Current system time is 24-AUG-2004 18:37:00
arcdcu()- Current system time is 24-AUG-2004 18:37:00
raafds()- Current system time is 24-AUG-2004 18:37:00
APP-11813 Error calling raapic()
 
Upvote 0 Downvote
J,

Thanks for the update. Let's focus on your code:
Code: 
update RA_CUSTOMER_TRX T set BILL_TO_SITE_USE_ID=(select SITE_USE_ID...
(First, the code as you posted it appears to be a fragment.)

The error you received typically occurs when trying to compare or assign multiple values on the right of the "=" operator to a single expression on the left of the "=" operator. In the case of an assignment (as you are doing in your UPDATE statement, you must assure that the SELECT statement ("(select SITE_USE_ID...)") returns exactly one row. If the subquery returns zero rows, then BILL_TO_SITE_USE_ID will become NULL (which is technically acceptable); if the subquery returns two or more rows, then Oracle definitely throws the error you received.

Therefore, to avoid your previous error, you must refine your WHERE clause to allow precisely one row. Currently, it allows more than one row in the result set.

Please make this adjustment, then advise us of your findings.

[santa]Mufasa
(aka Dave of Sandy, Utah, USA @ 06:29 (25Aug04) UTC (aka "GMT" and "Zulu"), 23:29 (24Aug04) Mountain Time)
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

rk68
  • Locked
  • Question
Data encryption in Oracle 19c
Replies
0
Views
246
rk68
rk68
TheLazyPig
  • Locked
  • Question
Inserting Text Decimal to Table Error
Replies
4
Views
993
carp
carp
TheLazyPig
  • Locked
  • Question
Merge Into with multiple execution 1
Replies
1
Views
855
carp
carp
annie1975
  • Locked
  • Question
sql script in an cron job script failing
Replies
3
Views
463
carp
carp
Livia8
  • Locked
  • Question
SQL script to find number of characters allowed in "Description" column of "AP_INVOIC 2
Replies
5
Views
543
Livia8
Livia8

Part and Inventory Search

Sponsor

Back
Top