DBA Data[Home] [Help]

APPS.CHV_BUILD_SCHEDULES dependencies on CHV_ITEM_ORDERS

Line 2070: chv_item_orders cio,

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)
2074: FROM po_headers poh2,

Line 2076: chv_item_orders cio2

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
2079: AND cio2.schedule_item_id = x_schedule_item_id_l
2080: AND poh2.po_header_id = pol2.po_header_id