DBA Data[Home] [Help]

APPS.OE_BULK_PROCESS_LINE dependencies on MTL_CROSS_REFERENCES

Line 722: FROM mtl_cross_references

718:
719: BEGIN
720: SELECT inventory_item_id
721: INTO l_inventory_item_id_gen
722: FROM mtl_cross_references
723: WHERE cross_reference_type = p_line_rec.item_identifier_type(p_index)
724: AND (organization_id = OE_BULK_ORDER_PVT.G_ITEM_ORG
725: OR organization_id IS NULL)
726: AND cross_reference = p_line_rec.ordered_item(p_index)

Line 1196: , mtl_cross_references items

1192: ELSE
1193: SELECT 'valid'
1194: INTO l_dummy
1195: FROM mtl_cross_reference_types types
1196: , mtl_cross_references items
1197: , mtl_system_items_vl sitems
1198: WHERE types.cross_reference_type = items.cross_reference_type
1199: AND items.inventory_item_id = sitems.inventory_item_id
1200: AND sitems.organization_id = OE_Bulk_Order_PVT.G_ITEM_ORG