DBA Data[Home] [Help]

APPS.CSL_MTL_SYSTEM_ITEMS_ACC_PKG dependencies on MTL_ITEM_CATEGORIES

Line 678: l_stmt := l_stmt || ' FROM mtl_item_categories itemcat';

674: IF (l_stmt1 IS NOT NULL) THEN
675: l_stmt := l_stmt || ' AND ';
676: l_stmt := l_stmt || ' inventory_item_id IN';
677: l_stmt := l_stmt || ' (SELECT inventory_item_id';
678: l_stmt := l_stmt || ' FROM mtl_item_categories itemcat';
679: l_stmt := l_stmt || ' WHERE ' || l_stmt1;
680: l_stmt := l_stmt || ' AND itemcat.organization_id = :3 )';
681: END IF;
682:

Line 830: FROM mtl_item_categories itemcat

826: AND material_billable_flag = billing_type (+)
827: AND NVL(cbtc.billing_category, 'M') = 'M'
828: AND inventory_item_id IN
829: (SELECT inventory_item_id
830: FROM mtl_item_categories itemcat
831: WHERE itemcat.category_id = b_category_id
832: AND itemcat.organization_id = b_organization_id
833: AND (b_changed = 'Y'
834: OR itemcat.creation_date >= NVL(b_last_run_date, itemcat.CREATION_DATE)));

Line 854: FROM mtl_item_categories itemcat

850: AND NVL(MATERIAL_BILLABLE_FLAG, 'M') = 'M'
851: AND ORGANIZATION_ID = b_organization_id
852: AND inventory_item_id IN
853: (SELECT inventory_item_id
854: FROM mtl_item_categories itemcat
855: WHERE itemcat.category_set_id = b_category_set_id
856: AND itemcat.organization_id = b_organization_id
857: AND (b_changed = 'Y'
858: OR itemcat.creation_date >= NVL(b_last_run_date, itemcat.CREATION_DATE)));

Line 877: FROM mtl_item_categories itemcat

873: AND material_billable_flag = billing_type (+)
874: AND NVL(cbtc.billing_category, 'M') = 'M'
875: AND inventory_item_id IN
876: (SELECT inventory_item_id
877: FROM mtl_item_categories itemcat
878: WHERE itemcat.category_id = b_category_id
879: AND itemcat.category_set_id = b_category_set_id
880: AND itemcat.organization_id = b_organization_id
881: AND (b_changed = 'Y'

Line 948: l_stmt := l_stmt || ' FROM mtl_item_categories itemcat';

944: IF (l_stmt1 IS NOT NULL) THEN
945: l_stmt := l_stmt || ' AND ';
946: l_stmt := l_stmt || ' inventory_item_id IN';
947: l_stmt := l_stmt || ' (SELECT inventory_item_id';
948: l_stmt := l_stmt || ' FROM mtl_item_categories itemcat';
949: l_stmt := l_stmt || ' WHERE ' || l_stmt1;
950: l_stmt := l_stmt || ' AND itemcat.organization_id = :3 )';
951: END IF;
952:

Line 1475: l_stmt := l_stmt || ' FROM mtl_item_categories itemcat';

1471: IF (l_stmt1 IS NOT NULL) THEN
1472: l_stmt := l_stmt || ' AND ';
1473: l_stmt := l_stmt || ' inventory_item_id IN';
1474: l_stmt := l_stmt || ' (SELECT inventory_item_id';
1475: l_stmt := l_stmt || ' FROM mtl_item_categories itemcat';
1476: l_stmt := l_stmt || ' WHERE ' || l_stmt1;
1477: l_stmt := l_stmt || ' AND itemcat.organization_id = :3 )';
1478: END IF;
1479: