DBA Data[Home] [Help]

APPS.RCV_TRANSACTIONS_INTERFACE_SV1 dependencies on MTL_RELATED_ITEMS

Line 517: FROM mtl_related_items

513: -- = 1 for related items
514:
515: SELECT NVL(MAX(inventory_item_id), 0)
516: INTO x_inventory_item
517: FROM mtl_related_items
518: WHERE inventory_item_id = (SELECT item_id
519: FROM po_lines
520: WHERE po_line_id = x_sub_item_id_record.po_line_id)
521: AND related_item_id = x_sub_item_id_record.substitute_item_id

Line 530: FROM mtl_related_items

526: -- Try the reciprocal relationship
527:
528: SELECT NVL(MAX(inventory_item_id), 0)
529: INTO x_inventory_item
530: FROM mtl_related_items
531: WHERE related_item_id = (SELECT item_id
532: FROM po_lines
533: WHERE po_line_id = x_sub_item_id_record.po_line_id)
534: AND inventory_item_id = x_sub_item_id_record.substitute_item_id