DBA Data[Home] [Help]

APPS.PO_PDOI_ATTR_PROCESS_PVT dependencies on MTL_MFG_PART_NUMBERS_ALL_V

Line 995: FROM mtl_mfg_part_numbers_all_v mmpn

991: mmpn.manufacturer_name
992: BULK COLLECT INTO l_item_id_tbl2,
993: l_mfg_part_num_tbl,
994: l_mfg_name_tbl
995: FROM mtl_mfg_part_numbers_all_v mmpn
996: WHERE row_id IN (SELECT MIN(mmpn2.row_id)
997: FROM mtl_mfg_part_numbers_all_v mmpn2,
998: po_attribute_values_draft pavd
999: WHERE pavd.inventory_item_id = mmpn2.inventory_item_id

Line 997: FROM mtl_mfg_part_numbers_all_v mmpn2,

993: l_mfg_part_num_tbl,
994: l_mfg_name_tbl
995: FROM mtl_mfg_part_numbers_all_v mmpn
996: WHERE row_id IN (SELECT MIN(mmpn2.row_id)
997: FROM mtl_mfg_part_numbers_all_v mmpn2,
998: po_attribute_values_draft pavd
999: WHERE pavd.inventory_item_id = mmpn2.inventory_item_id
1000: AND mmpn2.organization_id = l_master_org_id
1001: AND pavd.request_id = fnd_global.conc_request_id