DBA Data[Home] [Help]

APPS.ICX_CAT_POPULATE_ITEM_PVT dependencies on PO_REQEXPRESS_LINES_ALL

Line 4400: FROM po_reqexpress_lines_all prl, po_reqexpress_headers_all prh,

4396: WHERE hdrs.source_type IN ('TEMPLATE', 'INTERNAL_TEMPLATE')
4397: AND (
4398: -- Req template lines that are invalid.
4399: EXISTS ( SELECT 'x'
4400: FROM po_reqexpress_lines_all prl, po_reqexpress_headers_all prh,
4401: po_lines_all pl, po_headers_all ph
4402: WHERE hdrs.po_line_id = -2
4403: AND hdrs.inventory_item_id = nvl(prl.item_id, -2)
4404: AND hdrs.req_template_name = prl.express_name

Line 4426: FROM po_reqexpress_lines_all prl

4422: OR NVL(TRUNC(pl.expiration_date), TRUNC(SYSDATE + 1)) <= TRUNC(SYSDATE)))))
4423: OR
4424: -- Req template lines that are deleted.
4425: NOT EXISTS ( SELECT 'x'
4426: FROM po_reqexpress_lines_all prl
4427: WHERE hdrs.po_line_id = -2
4428: AND hdrs.inventory_item_id = nvl(prl.item_id, -2)
4429: AND hdrs.req_template_name = prl.express_name
4430: AND hdrs.req_template_line_num = prl.sequence_num