DBA Data[Home] [Help]

APPS.PO_PDOI_ATTR_PROCESS_PVT dependencies on MTL_MFG_PART_NUMBERS_ALL_V

Line 987: FROM mtl_mfg_part_numbers_all_v mmpn

983: mmpn.manufacturer_name
984: BULK COLLECT INTO l_item_id_tbl2,
985: l_mfg_part_num_tbl,
986: l_mfg_name_tbl
987: FROM mtl_mfg_part_numbers_all_v mmpn
988: WHERE row_id IN (SELECT MIN(mmpn2.row_id)
989: FROM mtl_mfg_part_numbers_all_v mmpn2,
990: po_attribute_values_draft pavd
991: WHERE pavd.inventory_item_id = mmpn2.inventory_item_id

Line 989: FROM mtl_mfg_part_numbers_all_v mmpn2,

985: l_mfg_part_num_tbl,
986: l_mfg_name_tbl
987: FROM mtl_mfg_part_numbers_all_v mmpn
988: WHERE row_id IN (SELECT MIN(mmpn2.row_id)
989: FROM mtl_mfg_part_numbers_all_v mmpn2,
990: po_attribute_values_draft pavd
991: WHERE pavd.inventory_item_id = mmpn2.inventory_item_id
992: AND mmpn2.organization_id = l_master_org_id
993: AND pavd.request_id = fnd_global.conc_request_id