APPS.PO_ATTRIBUTE_VALUES_PVT dependencies on MTL_MFG_PART_NUMBERS_ALL_V

Line 3779: SELECT * FROM MTL_MFG_PART_NUMBERS_ALL_V

3775:
3776: SELECT MFG_PART_NUM
3777: INTO l_manufacturer_part_num
3778: FROM(
3779: SELECT * FROM MTL_MFG_PART_NUMBERS_ALL_V
3780: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
3781: AND ORGANIZATION_ID = p_master_organization_id
3782: ORDER BY ROW_ID
3783: ) WHERE ROWNUM =1;

Line 4195: FROM MTL_MFG_PART_NUMBERS_ALL_V

4191: SELECT MFG_PART_NUM, MANUFACTURER_NAME
4192: INTO l_manufacturer_part_num, l_manufacturer
4193: FROM(
4194: SELECT MFG_PART_NUM,MANUFACTURER_NAME
4195: FROM MTL_MFG_PART_NUMBERS_ALL_V
4196: WHERE INVENTORY_ITEM_ID =p_inventory_item_id
4197: AND ORGANIZATION_ID = p_master_organization_id
4198: ORDER BY ROW_ID ) WHERE ROWNUM =1;
4199:

Line 6461: SELECT * FROM MTL_MFG_PART_NUMBERS_ALL_V

6457: Begin
6458: SELECT MANUFACTURER_NAME
6459: INTO l_manufacturer
6460: FROM(
6461: SELECT * FROM MTL_MFG_PART_NUMBERS_ALL_V
6462: WHERE INVENTORY_ITEM_ID =p_inventory_item_id
6463: AND ORGANIZATION_ID = p_master_organization_id
6464: ORDER BY ROW_ID ) WHERE ROWNUM =1;
6465: EXCEPTION

Line 6651: FROM mtl_mfg_part_numbers_all_v WHERE row_id =

6647: MANUFACTURER_ID
6648: INTO p_manufacturer_part_num,
6649: p_manufacturer,
6650: p_manufacturer_id
6651: FROM mtl_mfg_part_numbers_all_v WHERE row_id =
6652: (SELECT Min(row_id)
6653: FROM mtl_mfg_part_numbers_all_v
6654: WHERE inventory_item_id = p_inventory_item_id
6655: AND organization_id = l_master_organization_id);

Line 6653: FROM mtl_mfg_part_numbers_all_v

6649: p_manufacturer,
6650: p_manufacturer_id
6651: FROM mtl_mfg_part_numbers_all_v WHERE row_id =
6652: (SELECT Min(row_id)
6653: FROM mtl_mfg_part_numbers_all_v
6654: WHERE inventory_item_id = p_inventory_item_id
6655: AND organization_id = l_master_organization_id);
6656:
6657: