DBA Data[Home] [Help]

APPS.OE_BULK_PROCESS_LINE dependencies on MTL_CROSS_REFERENCES

Line 696: FROM mtl_cross_references

692:
693: BEGIN
694: SELECT inventory_item_id
695: INTO l_inventory_item_id_gen
696: FROM mtl_cross_references
697: WHERE cross_reference_type = p_line_rec.item_identifier_type(p_index)
698: AND (organization_id = OE_BULK_ORDER_PVT.G_ITEM_ORG
699: OR organization_id IS NULL)
700: AND cross_reference = p_line_rec.ordered_item(p_index)

Line 1170: , mtl_cross_references items

1166: ELSE
1167: SELECT 'valid'
1168: INTO l_dummy
1169: FROM mtl_cross_reference_types types
1170: , mtl_cross_references items
1171: , mtl_system_items_vl sitems
1172: WHERE types.cross_reference_type = items.cross_reference_type
1173: AND items.inventory_item_id = sitems.inventory_item_id
1174: AND sitems.organization_id = OE_Bulk_Order_PVT.G_ITEM_ORG