DBA Data[Home] [Help]

APPS.ICX_CAT_POPULATE_ITEM_PVT dependencies on PO_REQEXPRESS_LINES_ALL

Line 4425: FROM po_reqexpress_lines_all prl, po_reqexpress_headers_all prh,

4421: WHERE hdrs.source_type IN ('TEMPLATE', 'INTERNAL_TEMPLATE')
4422: AND (
4423: -- Req template lines that are invalid.
4424: EXISTS ( SELECT 'x'
4425: FROM po_reqexpress_lines_all prl, po_reqexpress_headers_all prh,
4426: po_lines_all pl, po_headers_all ph
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

Line 4451: FROM po_reqexpress_lines_all prl

4447: OR NVL(TRUNC(pl.expiration_date), TRUNC(SYSDATE + 1)) <= TRUNC(SYSDATE)))))
4448: OR
4449: -- Req template lines that are deleted.
4450: NOT EXISTS ( SELECT 'x'
4451: FROM po_reqexpress_lines_all prl
4452: WHERE hdrs.po_line_id = -2
4453: AND hdrs.inventory_item_id = nvl(prl.item_id, -2)
4454: AND hdrs.req_template_name = prl.express_name
4455: AND hdrs.req_template_line_num = prl.sequence_num