APPS.MSD_SR_UTIL dependencies on MTL_SYSTEM_ITEMS

Line 78: from mtl_system_items_kfv

74: if p_item_id is NULL then return 'Other'; end if;
75: if p_org_id is NULL then
76: select concatenated_segments
77: into l_item
78: from mtl_system_items_kfv
79: where inventory_item_id = p_item_id AND organization_id is NULL;
80: else
81: select concatenated_segments
82: into l_item

Line 83: from mtl_system_items_kfv

79: where inventory_item_id = p_item_id AND organization_id is NULL;
80: else
81: select concatenated_segments
82: into l_item
83: from mtl_system_items_kfv
84: where inventory_item_id = p_item_id AND organization_id = p_org_id;
85: end if;
86: return l_item;
87:

Line 175: from mtl_system_items

171: where parameter_name = 'MSD_MASTER_ORG';
172:
173: select NVL(primary_uom_code,'Ea')
174: into l_master_uom
175: from mtl_system_items
176: where inventory_item_id = item_id
177: and organization_id = l_master_org;
178:
179: conv_rate := inv_convert.inv_um_convert(item_id,NULL,NULL,uom_code,l_master_uom,NULL,NULL);

Line 202: from mtl_system_items

198: BEGIN
199: if p_item_id is null then return NULL; end if;
200: select list_price_per_unit
201: into l_ret
202: from mtl_system_items
203: where (p_item_id = inventory_item_id) and
204: ((organization_id = p_org_id) OR (organization_id is null));
205: return l_ret;
206:

Line 531: mtl_system_items msi, -- Parent

527: select 1
528: from
529: msd_app_instance_orgs morg,
530: bom_bill_of_materials bbm,
531: mtl_system_items msi, -- Parent
532: bom_inventory_components bic
533: where
534: bic.bill_sequence_id = bbm.bill_sequence_id
535: and bbm.organization_id = morg.organization_id

Line 573: mtl_system_items msi, -- Parent

569: select 1
570: from
571: msd_app_instance_orgs morg,
572: bom_bill_of_materials bbm,
573: mtl_system_items msi, -- Parent
574: bom_inventory_components bic
575: where
576: bic.bill_sequence_id = bbm.bill_sequence_id
577: and bbm.organization_id = morg.organization_id

Line 633: mtl_system_items msi, -- Parent

629: select 1
630: from
631: msd_app_instance_orgs morg,
632: bom_bill_of_materials bbm,
633: mtl_system_items msi, -- Parent
634: bom_inventory_components bic
635: where
636: bic.component_sequence_id = l_component_seq_id
637: and bic.bill_sequence_id = bbm.bill_sequence_id

Line 661: mtl_system_items msi,

657: select 1
658: from
659: msd_app_instance_orgs morg,
660: bom_bill_of_materials bbm,
661: mtl_system_items msi,
662: bom_inventory_components bic
663: where
664: bic.bill_sequence_id = bbm.bill_sequence_id
665: and bbm.organization_id = morg.organization_id

Line 723: mtl_system_items msi

719: CURSOR c_parent IS
720: SELECT assemb.assembly_item_id, msi.bom_item_type
721: FROM bom_bill_of_materials assemb,
722: bom_inventory_components comp,
723: mtl_system_items msi
724: WHERE
725: assemb.bill_sequence_id = comp.bill_sequence_id
726: and comp.component_sequence_id = p_comp_seq_id
727: and assemb.assembly_item_id = msi.inventory_item_id

Line 820: mtl_system_items parent

816: CURSOR c_count IS
817: SELECT
818: count(1)
819: FROM
820: mtl_system_items parent
821: WHERE
822: parent.organization_id = p_org_id and
823: parent.inventory_item_id = p_product_family_item_id and
824: parent.bom_item_type = 5 and

Line 831: mtl_system_items pf,

827: CURSOR c_count1 IS
828: SELECT
829: count(1)
830: FROM
831: mtl_system_items pf,
832: mtl_system_items parent
833: WHERE
834: pf.organization_id = p_org_id and
835: pf.inventory_item_id = p_inventory_item_id and

Line 832: mtl_system_items parent

828: SELECT
829: count(1)
830: FROM
831: mtl_system_items pf,
832: mtl_system_items parent
833: WHERE
834: pf.organization_id = p_org_id and
835: pf.inventory_item_id = p_inventory_item_id and
836: parent.organization_id = p_org_id and

Line 890: mtl_system_items parent,

886: CURSOR c_count IS
887: SELECT
888: count(1)
889: FROM
890: mtl_system_items parent,
891: bom_inventory_components bic,
892: bom_bill_of_materials bom
893: WHERE
894: parent.bom_item_type = 5 and

Line 942: from mtl_system_items itm

938: CURSOR c_config_model (p_header_id IN NUMBER,
939: p_org_id IN NUMBER,
940: p_ato_line_id IN NUMBER) IS
941: select count(1)
942: from mtl_system_items itm
943: where inventory_item_id = (select inventory_item_id
944: from oe_order_lines_all l
945: where l.item_type_code = 'CONFIG'
946: and l.header_id = p_header_id

Line 1335: from mtl_system_items_kfv

1331: BEGIN
1332:
1333: select mrp_planning_code,pick_components_flag
1334: into lv_mrp_planning_code,lv_pick_components_flag
1335: from mtl_system_items_kfv
1336: where inventory_item_id = p_inventory_item_id
1337: and organization_id = p_organization_id;
1338:
1339: If ( lv_mrp_planning_code <> 6 OR (lv_mrp_planning_code = 6 and lv_pick_components_flag ='Y')) THEN