DBA Data[Home] [Help]

APPS.OE_CNCL_VALIDATE_LINE dependencies on MTL_SYSTEM_ITEMS

Line 444: FROM mtl_system_items msi,

440: BEGIN
441: OE_DEBUG_PUB.Add('Entering OE_CNCL_VALIDATE_LINE.Validate_Receiving_Org',1);
442: SELECT null
443: INTO l_dummy
444: FROM mtl_system_items msi,
445: org_organization_definitions org
446: WHERE msi.inventory_item_id = p_inventory_item_id
447: AND org.organization_id= msi.organization_id
448: AND org.organization_id= p_ship_from_org_id

Line 490: FROM mtl_system_items msi,

486: nvl(p_top_model_line_id, -1) <> p_line_id)
487: THEN
488: SELECT null
489: INTO l_dummy
490: FROM mtl_system_items msi,
491: org_organization_definitions org
492: WHERE msi.inventory_item_id = p_inventory_item_id
493: AND org.organization_id= msi.organization_id
494: AND org.organization_id= p_ship_from_org_id

Line 499: FROM mtl_system_items msi,

495: AND rownum=1;
496: ELSE
497: SELECT null
498: INTO l_dummy
499: FROM mtl_system_items msi,
500: org_organization_definitions org
501: WHERE msi.inventory_item_id = p_inventory_item_id
502: AND org.organization_id= msi.organization_id
503: AND org.organization_id= p_ship_from_org_id

Line 603: FROM mtl_system_items_vl

599: oe_debug_pub.add('p_sold_to_org_id: '||p_sold_to_org_id);
600: IF nvl(p_item_identifier_type, 'INT') = 'INT' THEN
601: SELECT 'valid'
602: INTO l_dummy
603: FROM mtl_system_items_vl
604: WHERE inventory_item_id = p_inventory_item_id
605: AND organization_id = OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID');
606: ELSIF nvl(p_item_identifier_type, 'INT') = 'CUST' THEN
607: SELECT 'valid'

Line 611: ,mtl_system_items_vl sitems

607: SELECT 'valid'
608: INTO l_dummy
609: FROM mtl_customer_items citems
610: ,mtl_customer_item_xrefs cxref
611: ,mtl_system_items_vl sitems
612: WHERE citems.customer_item_id = cxref.customer_item_id
613: AND cxref.inventory_item_id = sitems.inventory_item_id
614: AND sitems.inventory_item_id = p_inventory_item_id
615: AND sitems.organization_id =

Line 628: , mtl_system_items_vl sitems

624: SELECT 'valid'
625: INTO l_dummy
626: FROM mtl_cross_reference_types types
627: , mtl_cross_references items
628: , mtl_system_items_vl sitems
629: WHERE types.cross_reference_type = items.cross_reference_type
630: AND items.inventory_item_id = sitems.inventory_item_id
631: AND sitems.organization_id =
632: OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID')

Line 788: FROM mtl_system_items

784: oe_debug_pub.add('Entering Validate_Return_Item',1);
785:
786: SELECT nvl(returnable_flag,'Y')
787: INTO l_returnable_flag
788: FROM mtl_system_items
789: WHERE inventory_item_id = p_inventory_item_id
790: and organization_id = nvl(p_ship_from_org_id,
791: oe_sys_parameters.value_wnps('MASTER_ORGANIZATION_ID'));
792:

Line 1080: FROM mtl_system_items msi,

1076: p_line_rec.item_type_code in ('MODEL', 'CLASS')) THEN
1077:
1078: SELECT purchasing_enabled_flag
1079: INTO l_purchasing_enabled_flag
1080: FROM mtl_system_items msi,
1081: org_organization_definitions org
1082: WHERE msi.inventory_item_id = p_line_rec.inventory_item_id
1083: AND org.organization_id= msi.organization_id
1084: AND sysdate <= nvl( org.disable_date, sysdate)

Line 1148: FROM mtl_system_items

1144: , discrete_item_id IN NUMBER) IS
1145: SELECT tracking_quantity_ind,
1146: secondary_uom_code,
1147: secondary_default_ind
1148: FROM mtl_system_items
1149: WHERE organization_id = discrete_org_id
1150: AND inventory_item_id = discrete_item_id;
1151:
1152: /*OPM 02/JUN/00 BEGIN

Line 2425: FROM mtl_system_items

2421: p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION ) THEN
2422: BEGIN
2423: SELECT primary_uom_code
2424: INTO l_uom
2425: FROM mtl_system_items
2426: WHERE inventory_item_id = p_line_rec.inventory_item_id
2427: AND organization_id = nvl(p_line_rec.ship_from_org_id,
2428: OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID'));
2429:

Line 3923: FROM mtl_system_items

3919: oe_debug_pub.add('inventory_item_id ' || p_line_rec.inventory_item_id);
3920: BEGIN
3921: SELECT OE_GLOBALS.G_ITEM_KIT
3922: INTO l_item_type_code
3923: FROM mtl_system_items
3924: WHERE organization_id
3925: = OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID')
3926: AND inventory_item_id = p_line_rec.inventory_item_id
3927: AND pick_components_flag = 'Y';