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_HEADERS

Line 2069: FROM po_headers poh,

2065: */
2066:
2067: SELECT min(poh.po_header_id)
2068: INTO x_po_header_id_l
2069: FROM po_headers poh,
2070: chv_item_orders cio,
2071: po_lines pol
2072: WHERE poh.creation_date =
2073: (SELECT min(poh2.creation_date)

Line 2074: FROM po_headers poh2,

2070: chv_item_orders cio,
2071: po_lines pol
2072: WHERE poh.creation_date =
2073: (SELECT min(poh2.creation_date)
2074: FROM po_headers poh2,
2075: po_lines pol2,
2076: chv_item_orders cio2
2077: WHERE cio2.schedule_id = x_schedule_id
2078: AND poh2.po_header_id = cio2.document_header_id

Line 2113: po_headers poh

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'
2117: AND poh.po_header_id = document_header_id

Line 2144: , po_headers poh

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'
2148: AND nvl(poh.cancel_flag,'N') = 'N'

Line 2165: FROM po_headers poh,

2161: */
2162:
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)

Line 2170: FROM po_headers poh2,

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,
2172: po_asl_documents pad2
2173: WHERE poh2.po_header_id = pad2.document_header_id
2174: AND pad2.asl_id = x_asl_id_l

Line 2209: FROM po_headers poh,

2205: */
2206:
2207: SELECT min(poh.po_header_id)
2208: INTO x_po_header_id_l
2209: FROM po_headers poh,
2210: po_lines pol
2211: WHERE poh.creation_date =
2212: (SELECT min(poh2.creation_date)
2213: FROM po_headers poh2,

Line 2213: FROM po_headers poh2,

2209: FROM po_headers poh,
2210: po_lines pol
2211: WHERE poh.creation_date =
2212: (SELECT min(poh2.creation_date)
2213: FROM po_headers poh2,
2214: po_lines pol2
2215: WHERE poh2.po_header_id = pol2.po_header_id
2216: AND pol2.item_id = x_item_id_l
2217: AND poh2.type_lookup_code = 'BLANKET'