DBA Data[Home] [Help]

APPS.PO_PDOI_LINE_PROCESS_PVT dependencies on MTL_CATEGORIES_KFV

Line 7443: FROM mtl_categories_kfv mck

7439: AND NVL(draft_lines.expiration_date, TRUNC(sysdate)) >= TRUNC(sysdate)
7440: AND draft_lines.item_description = x_lines.item_desc_tbl(i)
7441: AND (x_lines.category_tbl(i) IS NULL OR
7442: EXISTS ( SELECT 1
7443: FROM mtl_categories_kfv mck
7444: WHERE mck.concatenated_segments = x_lines.category_tbl(i)
7445: AND mck.category_id = draft_lines.category_id));
7446:
7447: d_position := 10;

Line 7472: FROM mtl_categories_kfv mck

7468: AND draft_lines.draft_id = x_lines.draft_id_tbl(i))
7469: AND txn_lines.item_description = x_lines.item_desc_tbl(i)
7470: AND (x_lines.category_tbl(i) IS NULL OR
7471: EXISTS ( SELECT 1
7472: FROM mtl_categories_kfv mck
7473: WHERE mck.concatenated_segments = x_lines.category_tbl(i)
7474: AND mck.category_id = txn_lines.category_id))
7475: AND NVL(txn_lines.expiration_date, TRUNC(sysdate)) >= TRUNC(sysdate)
7476: AND NVL(txn_lines.closed_code, 'OPEN') <> 'FINALLY CLOSED'