DBA Data[Home] [Help]

APPS.POR_AMENDMENT_PKG dependencies on MTL_SYSTEM_ITEMS

Line 1394: FROM mtl_system_items_kfv msi,

1390: ELSIF label IN ('ITEM_ID') THEN
1391:
1392: SELECT msi.concatenated_segments
1393: INTO id
1394: FROM mtl_system_items_kfv msi,
1395: financials_system_parameters fsp
1396: WHERE p_id = msi.inventory_item_id (+)
1397: AND fsp.inventory_organization_id = NVL(msi.organization_id,fsp.inventory_organization_id );
1398:

Line 6188: FROM mtl_system_items msi

6184: BEGIN
6185:
6186: SELECT msi.inspection_required_flag
6187: INTO x_item_inspection_req_flag
6188: FROM mtl_system_items msi
6189: WHERE msi.inventory_item_id = x_item_id
6190: AND msi.organization_id = x_destination_organization_id;
6191:
6192: EXCEPTION