APPS.PO_DRAFT_MERGE_PKG dependencies on PO_LINES_ALL

Line 2071: FROM po_lines_all pol

2067: poll.clm_delivery_period_uom)
2068: WHERE poll.po_header_id = p_document_id
2069: AND poll.po_release_id IS NULL
2070: AND EXISTS (SELECT 'ADC/ANA Delivery Event used'
2071: FROM po_lines_all pol
2072: WHERE pol.po_header_id = poll.po_header_id
2073: AND pol.po_line_id = poll.po_line_id
2074: AND pol.clm_delivery_event_code IN ( 'ADC', 'ANA' ))
2075: AND poll.need_by_date IS NULL

Line 2096: FROM po_lines_all pol

2092: poll.clm_delivery_period_uom)
2093: WHERE poll.po_header_id = p_document_id
2094: AND poll.po_release_id IS NULL
2095: AND EXISTS (SELECT 'ADC/ANA Delivery Event used'
2096: FROM po_lines_all pol
2097: WHERE pol.po_header_id = poll.po_header_id
2098: AND pol.po_line_id = poll.po_line_id
2099: AND pol.clm_delivery_event_code IN ( 'ADC', 'ANA' ))
2100: AND poll.need_by_date IS NULL

Line 2138: FROM po_lines_all pol

2134: + Nvl(DAYS_LATE_RECEIPT_ALLOWED,0)
2135: WHERE poll.po_header_id = p_document_id
2136: AND poll.po_release_id IS NULL
2137: AND EXISTS (SELECT 'ADC/ANA Delivery Event used'
2138: FROM po_lines_all pol
2139: WHERE pol.po_header_id = poll.po_header_id
2140: AND pol.po_line_id = poll.po_line_id
2141: AND pol.clm_delivery_event_code IN ( 'ADC', 'ANA' ))
2142: AND poll.promised_date IS NULL

Line 2164: FROM po_lines_all pol

2160: + Nvl(DAYS_LATE_RECEIPT_ALLOWED,0)
2161: WHERE poll.po_header_id = p_document_id
2162: AND poll.po_release_id IS NULL
2163: AND EXISTS (SELECT 'ADC/ANA Delivery Event used'
2164: FROM po_lines_all pol
2165: WHERE pol.po_header_id = poll.po_header_id
2166: AND pol.po_line_id = poll.po_line_id
2167: AND pol.clm_delivery_event_code IN ( 'ADC', 'ANA' ))
2168: AND poll.promised_date IS NULL

Line 2199: FROM po_lines_all pol

2195: poll.clm_delivery_period_uom)
2196: WHERE poll.po_header_id = p_document_id
2197: AND poll.po_release_id IS NULL
2198: AND EXISTS (SELECT 'ADC/ANA Delivery Event used'
2199: FROM po_lines_all pol
2200: WHERE pol.po_header_id = poll.po_header_id
2201: AND pol.po_line_id = poll.po_line_id
2202: AND pol.clm_delivery_event_code IN ( 'ADC', 'ANA' ))
2203: AND poll.need_by_date IS NULL

Line 2224: FROM po_lines_all pol

2220: poll.clm_delivery_period_uom)
2221: WHERE poll.po_header_id = p_document_id
2222: AND poll.po_release_id IS NULL
2223: AND EXISTS (SELECT 'ADC/ANA Delivery Event used'
2224: FROM po_lines_all pol
2225: WHERE pol.po_header_id = poll.po_header_id
2226: AND pol.po_line_id = poll.po_line_id
2227: AND pol.clm_delivery_event_code IN ( 'ADC', 'ANA' ))
2228: AND poll.need_by_date IS NULL

Line 2261: FROM po_lines_all pol

2257: poll.CLM_POP_DURATION_UOM)
2258: WHERE poll.po_header_id = p_document_id
2259: AND poll.po_release_id IS NULL
2260: AND EXISTS (SELECT 'ADC/ANA Delivery Event used'
2261: FROM po_lines_all pol
2262: WHERE pol.po_header_id = poll.po_header_id
2263: AND pol.po_line_id = poll.po_line_id
2264: AND pol.clm_delivery_event_code IN ( 'ADC', 'ANA' ))
2265: AND poll.need_by_date IS NULL

Line 2286: FROM po_lines_all pol

2282: poll.CLM_POP_DURATION_UOM)
2283: WHERE poll.po_header_id = p_document_id
2284: AND poll.po_release_id IS NULL
2285: AND EXISTS (SELECT 'ADC/ANA Delivery Event used'
2286: FROM po_lines_all pol
2287: WHERE pol.po_header_id = poll.po_header_id
2288: AND pol.po_line_id = poll.po_line_id
2289: AND pol.clm_delivery_event_code IN ( 'ADC', 'ANA' ))
2290: AND poll.need_by_date IS NULL

Line 2323: FROM po_lines_all pol

2319: FROM po_line_locations_all poll
2320: WHERE poll.po_header_id = p_document_id
2321: AND poll.po_release_id IS NULL
2322: AND EXISTS (SELECT 'ADC/ANA Delivery Event used'
2323: FROM po_lines_all pol
2324: WHERE pol.po_header_id = poll.po_header_id
2325: AND pol.po_line_id = poll.po_line_id
2326: AND pol.clm_delivery_event_code IN ( 'ADC', 'ANA' ))
2327: AND ( p_draft_id = -1