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.CHV_BUILD_SCHEDULES dependencies on PO_ASL_DOCUMENTS

Line 2112: FROM po_asl_documents,

2108: */
2109:
2110: SELECT count(*)
2111: INTO x_number_of_blanket_agreements
2112: FROM po_asl_documents,
2113: po_headers poh
2114: WHERE asl_id = x_asl_id_l
2115: AND using_organization_id = x_using_org_id_l
2116: AND document_type_code = 'BLANKET'

Line 2143: FROM po_asl_documents

2139: SELECT document_header_id,
2140: document_line_id
2141: INTO x_po_header_id_l,
2142: x_po_line_id_l
2143: FROM po_asl_documents
2144: , po_headers poh
2145: WHERE document_type_code = 'BLANKET'
2146: AND poh.po_header_id = document_header_id
2147: AND nvl(poh.supply_agreement_flag,'N') = 'Y'

Line 2167: po_asl_documents pad

2163: SELECT min(poh.po_header_id)
2164: INTO x_po_header_id_l
2165: FROM po_headers poh,
2166: po_lines pol,
2167: po_asl_documents pad
2168: WHERE poh.creation_date =
2169: (SELECT min(poh2.creation_date)
2170: FROM po_headers poh2,
2171: po_lines pol2,

Line 2172: po_asl_documents pad2

2168: WHERE poh.creation_date =
2169: (SELECT min(poh2.creation_date)
2170: FROM po_headers poh2,
2171: po_lines pol2,
2172: po_asl_documents pad2
2173: WHERE poh2.po_header_id = pad2.document_header_id
2174: AND pad2.asl_id = x_asl_id_l
2175: AND pad2.using_organization_id = x_using_org_id_l
2176: AND poh2.po_header_id = pol2.po_header_id

Line 2194: po_asl_documents

2190:
2191: SELECT min(pol.po_line_id)
2192: INTO x_po_line_id_l
2193: FROM po_lines pol,
2194: po_asl_documents
2195: WHERE pol.po_header_id = x_po_header_id_l
2196: AND pol.item_id = x_item_id_l
2197: AND pol.po_header_id = document_header_id
2198: AND nvl(pol.cancel_flag,'N') = 'N'