i am getting a problem with Internal Sale Order that no existing po's for Internal Sale Order.
from where i get the po numbers of a ISO.
Thanks,
surekha.
Internal Sale Order
Easiest way query the back end ..
Execute this query..
select segment1 from po_headers_all where created_by='YOUR ID" and creation_date='THE DATE WHEN YOU CREATED"
If the system created the PO, you will see from here. if not you got to check the ISO process work flow where it got strucked..
Hope that helps.
Vinoth
Execute this query..
select segment1 from po_headers_all where created_by='YOUR ID" and creation_date='THE DATE WHEN YOU CREATED"
If the system created the PO, you will see from here. if not you got to check the ISO process work flow where it got strucked..
Hope that helps.
Vinoth
-
- Posts: 615
- Joined: Mon Sep 18, 2006 1:32 am
- Location: United Arab Emirates
- Contact:
-
- Posts: 615
- Joined: Mon Sep 18, 2006 1:32 am
- Location: United Arab Emirates
- Contact:
SELECT
A.ORG_ID ?ORG ID?,
E.VENDOR_NAME ?VENDOR NAME?,
UPPER(E.VENDOR_TYPE_LOOKUP_CODE) ?VENDOR TYPE?,
F.VENDOR_SITE_CODE ?VENDOR SITE?,
F.ADDRESS_LINE1 ?ADDRESS?,
F.CITY ?CITY?,
F.COUNTRY ?COUNTRY?,
TO_CHAR(TRUNC(D.CREATION_DATE)) ?PO DATE?,
D.SEGMENT1 ?PO NUMBER?,
D.TYPE_LOOKUP_CODE ?PO TYPE?,
C.QUANTITY_ORDERED ?QTY ORDERED?,
C.QUANTITY_CANCELLED ?QTY CANCALLED?,
G.ITEM_DESCRIPTION ?ITEM DESCRIPTION?,
G.UNIT_PRICE ?UNIT PRICE?,
(NVL(C.QUANTITY_ORDERED,0)-NVL(C.QUANTITY_CANCELLED,0))*NVL(G.UNIT_PRICE,0) ?PO Line Amount?,
(SELECT
DECODE(PH.APPROVED_FLAG, ?Y?, ?Approved?)
FROM PO.PO_HEADERS_ALL PH
WHERE PH.PO_HEADER_ID = D.PO_HEADER_ID) ?PO STATUS?,
A.INVOICE_TYPE_LOOKUP_CODE ?INVOICE TYPE?,
A.INVOICE_AMOUNT ?INVOICE AMOUNT?,
TO_CHAR(TRUNC(A.INVOICE_DATE)) ?INVOICE DATE?,
A.INVOICE_NUM ?INVOICE NUMBER?,
(SELECT
DECODE(X.MATCH_STATUS_FLAG, ?A?, ?Approved?)
FROM AP.AP_INVOICE_DISTRIBUTIONS_ALL X
WHERE X.INVOICE_DISTRIBUTION_ID = B.INVOICE_DISTRIBUTION_ID)?Invoice Approved??,
A.AMOUNT_PAID,
H.AMOUNT,
I.CHECK_NUMBER ?CHEQUE NUMBER?,
TO_CHAR(TRUNC(I.CHECK_DATE)) ?PAYMENT DATE?
FROM AP.AP_INVOICES_ALL A,
AP.AP_INVOICE_DISTRIBUTIONS_ALL B,
PO.PO_DISTRIBUTIONS_ALL C,
PO.PO_HEADERS_ALL D,
PO.PO_VENDORS E,
PO.PO_VENDOR_SITES_ALL F,
PO.PO_LINES_ALL G,
AP.AP_INVOICE_PAYMENTS_ALL H,
AP.AP_CHECKS_ALL I
WHERE A.INVOICE_ID = B.INVOICE_ID
AND B.PO_DISTRIBUTION_ID = C. PO_DISTRIBUTION_ID (+)
AND C.PO_HEADER_ID = D.PO_HEADER_ID (+)
AND E.VENDOR_ID (+) = D.VENDOR_ID
AND F.VENDOR_SITE_ID (+) = D.VENDOR_SITE_ID
AND D.PO_HEADER_ID = G.PO_HEADER_ID
AND C.PO_LINE_ID = G.PO_LINE_ID
AND A.INVOICE_ID = H.INVOICE_ID
AND H.CHECK_ID = I.CHECK_ID
AND F.VENDOR_SITE_ID = I.VENDOR_SITE_ID
AND C.PO_HEADER_ID IS NOT NULL
AND A.PAYMENT_STATUS_FLAG = ?Y?
AND D.TYPE_LOOKUP_CODE != ?BLANKET?;
<b>http://www.oracleappshub.com/account-pa ... -query/</b>
A.ORG_ID ?ORG ID?,
E.VENDOR_NAME ?VENDOR NAME?,
UPPER(E.VENDOR_TYPE_LOOKUP_CODE) ?VENDOR TYPE?,
F.VENDOR_SITE_CODE ?VENDOR SITE?,
F.ADDRESS_LINE1 ?ADDRESS?,
F.CITY ?CITY?,
F.COUNTRY ?COUNTRY?,
TO_CHAR(TRUNC(D.CREATION_DATE)) ?PO DATE?,
D.SEGMENT1 ?PO NUMBER?,
D.TYPE_LOOKUP_CODE ?PO TYPE?,
C.QUANTITY_ORDERED ?QTY ORDERED?,
C.QUANTITY_CANCELLED ?QTY CANCALLED?,
G.ITEM_DESCRIPTION ?ITEM DESCRIPTION?,
G.UNIT_PRICE ?UNIT PRICE?,
(NVL(C.QUANTITY_ORDERED,0)-NVL(C.QUANTITY_CANCELLED,0))*NVL(G.UNIT_PRICE,0) ?PO Line Amount?,
(SELECT
DECODE(PH.APPROVED_FLAG, ?Y?, ?Approved?)
FROM PO.PO_HEADERS_ALL PH
WHERE PH.PO_HEADER_ID = D.PO_HEADER_ID) ?PO STATUS?,
A.INVOICE_TYPE_LOOKUP_CODE ?INVOICE TYPE?,
A.INVOICE_AMOUNT ?INVOICE AMOUNT?,
TO_CHAR(TRUNC(A.INVOICE_DATE)) ?INVOICE DATE?,
A.INVOICE_NUM ?INVOICE NUMBER?,
(SELECT
DECODE(X.MATCH_STATUS_FLAG, ?A?, ?Approved?)
FROM AP.AP_INVOICE_DISTRIBUTIONS_ALL X
WHERE X.INVOICE_DISTRIBUTION_ID = B.INVOICE_DISTRIBUTION_ID)?Invoice Approved??,
A.AMOUNT_PAID,
H.AMOUNT,
I.CHECK_NUMBER ?CHEQUE NUMBER?,
TO_CHAR(TRUNC(I.CHECK_DATE)) ?PAYMENT DATE?
FROM AP.AP_INVOICES_ALL A,
AP.AP_INVOICE_DISTRIBUTIONS_ALL B,
PO.PO_DISTRIBUTIONS_ALL C,
PO.PO_HEADERS_ALL D,
PO.PO_VENDORS E,
PO.PO_VENDOR_SITES_ALL F,
PO.PO_LINES_ALL G,
AP.AP_INVOICE_PAYMENTS_ALL H,
AP.AP_CHECKS_ALL I
WHERE A.INVOICE_ID = B.INVOICE_ID
AND B.PO_DISTRIBUTION_ID = C. PO_DISTRIBUTION_ID (+)
AND C.PO_HEADER_ID = D.PO_HEADER_ID (+)
AND E.VENDOR_ID (+) = D.VENDOR_ID
AND F.VENDOR_SITE_ID (+) = D.VENDOR_SITE_ID
AND D.PO_HEADER_ID = G.PO_HEADER_ID
AND C.PO_LINE_ID = G.PO_LINE_ID
AND A.INVOICE_ID = H.INVOICE_ID
AND H.CHECK_ID = I.CHECK_ID
AND F.VENDOR_SITE_ID = I.VENDOR_SITE_ID
AND C.PO_HEADER_ID IS NOT NULL
AND A.PAYMENT_STATUS_FLAG = ?Y?
AND D.TYPE_LOOKUP_CODE != ?BLANKET?;
<b>http://www.oracleappshub.com/account-pa ... -query/</b>
Who is online
Users browsing this forum: Google Adsense [Bot] and 2 guests