eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_CONSUMPTION_ADVICE_PROC dependencies on PO_ASL_DOCUMENTS

Line 2157: Supplier List. There is no check for the presence of a record in the table po_asl_documents if

2153: FROM DUAL;
2154:
2155: /* Bug 7231720 If the Profile Option PO: Automatic Document Sourcing is set to "Yes" then
2156: the latest valid blanket must be picked even if the blanket is not present in the Approved
2157: Supplier List. There is no check for the presence of a record in the table po_asl_documents if
2158: the Profile Option PO: Automatic Document Sourcing is set to "No". The blanket is picked up
2159: from MMT.TRANSACTION_SOURCE_ID when the profile is set to "No" */
2160:
2161: IF (nvl(fnd_profile.value('PO_AUTO_SOURCE_DOC'),'N') = 'Y') THEN

Line 2306: FROM po_asl_documents

2302: the line specified on the ASL should be picked */
2303: -- AND ROWNUM = 1;
2304: AND EXISTS
2305: (SELECT 1
2306: FROM po_asl_documents
2307: WHERE asl_id = l_asl_id
2308: AND document_line_id = pla.po_line_id
2309: AND document_header_id = l_blanket_id
2310: AND using_organization_id in (-1, l_organization_id)); -- Bug 7165111 : Added -1 for global ASL