DBA Data[Home] [Help]

APPS.INVIDIT2 dependencies on MTL_CATEGORY_SETS_B

Line 870: mtl_category_sets_b s

866: l_organizations_rec
867: ,l_category_sets_rec
868: ,l_categories_rec
869: FROM
870: mtl_category_sets_b s
871: , mtl_parameters p
872: WHERE
873: p.master_organization_id = X_master_org_id
874: AND s.default_category_id IS NOT NULL --Bug: 2801594

Line 954: mtl_category_sets_b s

950: BULK COLLECT INTO
951: l_category_sets_rec
952: ,l_categories_rec
953: FROM
954: mtl_category_sets_b s
955: WHERE
956: s.category_set_id IN
957: ( SELECT d.category_set_id
958: FROM mtl_default_category_sets d

Line 1185: mtl_category_sets_b s

1181: l_organizations_rec
1182: ,l_category_sets_rec
1183: ,l_categories_rec
1184: FROM
1185: mtl_category_sets_b s
1186: , mtl_parameters p
1187: WHERE
1188: p.master_organization_id = X_master_org_id
1189: AND s.default_category_id IS NOT NULL --Bug: 2801594

Line 1335: mtl_category_sets_b s

1331: -1,
1332: sysdate,
1333: -1
1334: FROM
1335: mtl_category_sets_b s
1336: , mtl_item_categories c
1337: WHERE
1338: c.inventory_item_id = X_item_id
1339: AND c.organization_id = X_master_org_id

Line 1379: mtl_category_sets_b s

1375: BULK COLLECT INTO
1376: l_category_sets_rec
1377: ,l_categories_rec
1378: FROM
1379: mtl_category_sets_b s
1380: , mtl_item_categories c
1381: WHERE
1382: c.inventory_item_id = X_item_id
1383: AND c.organization_id = X_master_org_id

Line 1549: from mtl_category_sets_B s

1545: -1,
1546: NULL,
1547: -1,
1548: X_org_id
1549: from mtl_category_sets_B s
1550: where s.category_set_id in
1551: (select d.category_set_id
1552: from mtl_default_category_sets d
1553: where d.functional_area_id = 5)