DBA Data[Home] [Help]

APPS.PO_PDOI_LINE_PROCESS_PVT dependencies on MTL_CATEGORIES_KFV

Line 6476: FROM mtl_categories_kfv mck

6472: AND NVL(draft_lines.expiration_date, TRUNC(sysdate)) >= TRUNC(sysdate)
6473: AND draft_lines.item_description = x_lines.item_desc_tbl(i)
6474: AND (x_lines.category_tbl(i) IS NULL OR
6475: EXISTS ( SELECT 1
6476: FROM mtl_categories_kfv mck
6477: WHERE mck.concatenated_segments = x_lines.category_tbl(i)
6478: AND mck.category_id = draft_lines.category_id));
6479:
6480: d_position := 10;

Line 6505: FROM mtl_categories_kfv mck

6501: AND draft_lines.draft_id = x_lines.draft_id_tbl(i))
6502: AND txn_lines.item_description = x_lines.item_desc_tbl(i)
6503: AND (x_lines.category_tbl(i) IS NULL OR
6504: EXISTS ( SELECT 1
6505: FROM mtl_categories_kfv mck
6506: WHERE mck.concatenated_segments = x_lines.category_tbl(i)
6507: AND mck.category_id = txn_lines.category_id))
6508: AND NVL(txn_lines.expiration_date, TRUNC(sysdate)) >= TRUNC(sysdate)
6509: AND NVL(txn_lines.closed_code, 'OPEN') <> 'FINALLY CLOSED'