DBA Data[Home] [Help]

APPS.INVIDIT2 dependencies on MTL_PARAMETERS

Line 359: from mtl_parameters p

355: sysdate,
356: l_user_id,
357: sysdate,
358: l_user_id
359: from mtl_parameters p
360: where p.master_organization_id = X_master_org_id
361: and exists (select 'x' from mtl_system_items_B i
362: where i.inventory_item_id =
363: X_item_id

Line 472: from mtl_parameters

468: starting_revision,
469: starting_revision,-- Bug:3017253
470: l_revision_id,
471: 1
472: from mtl_parameters
473: where organization_id = X_org_id;
474:
475: INSERT INTO MTL_ITEM_REVISIONS_TL (
476: INVENTORY_ITEM_ID,

Line 539: from mtl_parameters

535: starting_revision,
536: starting_revision,-- Bug:3017253
537: l_revision_id,
538: 1
539: from mtl_parameters
540: where organization_id = X_org_id;
541:
542: INSERT INTO MTL_ITEM_REVISIONS_TL (
543: INVENTORY_ITEM_ID,

Line 871: , mtl_parameters p

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
875: AND s.category_set_id =

Line 1066: mtl_parameters p

1062: p.organization_id
1063: BULK COLLECT INTO
1064: l_organizations_rec
1065: FROM
1066: mtl_parameters p
1067: WHERE
1068: p.master_organization_id = X_master_org_id
1069: AND EXISTS
1070: ( SELECT 'x'

Line 1145: FROM mtl_parameters p

1141: WHERE
1142: inventory_item_id = X_item_id
1143: AND organization_id IN
1144: ( SELECT p.organization_id
1145: FROM mtl_parameters p
1146: WHERE
1147: p.master_organization_id = X_master_org_id
1148: )
1149: AND category_set_id = p_Folder_Category_Set_id

Line 1186: , mtl_parameters p

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
1190: AND s.category_set_id IN

Line 1628: from mtl_parameters

1624: INVIDIT2.Insert_Costing_Category(X_item_id, X_org_id);
1625:
1626: select primary_cost_method
1627: into cost_method
1628: from mtl_parameters
1629: where organization_id = X_org_id;
1630:
1631: begin
1632: